Use a VBA macro to get rid of line breaks in a number of workbooks. Remove all carriage returns manually to quickly delete line breaks in 1 worksheet.ĭelete line breaks using formulas to employ several formulas for a complex cell text processing. Feel free to pick the one that suites you best: In any case, what you want to do now is delete carriage returns since they don't let you find a phrase and make column contents look dis-organized when you turn on the wrap text option.Īll these 3 ways are really quick.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |