Problem with line breaks.

How to remove line breaks in Number? or even excel in Mac?

Posted on Apr 12, 2022 10:14 AM

Reply
6 replies

Apr 12, 2022 5:22 PM in response to shaidam3

It will be quite a mess on one line but one thing you can do is use Find/Replace (Command F) to get rid of them. In the "Find" box type in "\n", without the quotes. Leave the "replace" box empty. If you want to replace them everywhere in your document (all cells in all tables on all sheets), click on "replace all". There is no way to limit Find/Replace to a table or selected cells.


You will probably need to turn word wrap off also. Otherwise it will wrap to multiple lines to fit in the cell.

This thread has been closed by the system or the community team. You may vote for any posts you find helpful, or search the Community for additional answers.

Problem with line breaks.

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple Account.