deleting all manual cell breaks in an excel sheet

Copper Contributor

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

3 Replies
best response confirmed by mithke1580 (Copper Contributor)

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

Thanks a lot, works out perfectly. Yours, Michael

You're welcome @mithke1580 

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


Thanks & Nice day...