![]() ![]() 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 |