![]() In the Replace With field, enter any value to replace carriage It will look empty, but you will see a tiny dot. ![]() Press Ctrl+H to open the Find & Replace dialog box. Please find the steps for eliminating line breaks using Find and Replace: Select all cells where you want to remove or replace carriage returns. Find and replace carriage return in excel macģ ways to remove carriage returns in Excel: formulas, VBA macro, As line-break is CHAR(13), you could try something like this (assuming your text is in A1 ://In Word ctrl + F ( Command + F for Mac) - To Find and Replace.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |