deleting all manual cell breaks in an excel sheet

[mithke1580]

Hi there, I receive a file in which a lot of cells are manually breaked which bothers further processing. I want to delete the break kind of automatically. Someone know how to that

[#2 · Accepted solution]

Hi @mithke1580 

If cell break means Line Feed inside cell:

- Select the columns

- Ctrl+H

- In Find what: press Ctrl+J

- In Replace with: space or any other char you expect

[#3]

Thanks a lot, works out perfectly. Yours, Michael

[#4]

You're welcome @mithke1580 

Feel free to mark as solution => Can help people who Search

Thanks & Nice day...