Note: Initially the terms 'Carriage return' and 'Line feed' were used in a typewriter and meant 2 different actions, you can find more at Wiki.Ĭomputers and text processing software were created taking into consideration the typewriter specificities. 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.