Forum Discussion
Solved
deleting all manual cell breaks in an excel sheet
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
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
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...
