![]() ![]() In case you want to remove the line break and want to replace it with something else instead of the comma, then you need to specify that in Step 6 (in the ‘Replace with’ field) This will give you the result in a single line in a cell in Excel. The above steps would remove all the line breaks and replace these with a comma. In the replace field, enter a comma followed by a space character (, ).You may not see anything, but this puts the line break character in the ‘Find what’ field Place the cursor in the ‘Find what’ field and use the keyboard shortcut – Control + J (hold the Control key and press the J key).In the options that show up, click on ‘Replace’.In the Editing group, click on ‘Find & Select’. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |