How do I delete a line break from a spreadsheet in Numbers?

How do I delete a line break from a spreadsheet in Numbers?


MacBook

Posted on Sep 2, 2020 2:26 PM

Reply
3 replies

Sep 3, 2020 5:03 AM in response to jenniferfromcastro valley

You may have to explain what you mean a little further. The answer to the questions is way too simple (select the line break and hit delete, just like you would do with a line break in pretty much any other application) for this to be what you really mean.


Maybe you mean text wrapping where words will move to additional lines if the cell is not wide enough?


Sep 3, 2020 6:08 AM in response to jenniferfromcastro valley

Hi Jennifer,


Select the text to reveal the line breaks (if any).




If there are line breaks, select just one and menu > Edit > Find > Use Selection for Find (command E).



Then Menu > Edit > Find... (command F)



A hard return appears as \n (or you can simply type \n in the Find box.



A soft return appears as \i (or you can simply type \i in the Find box.


In the Replace box, leave it empty or type a space, depending upon how the line breaks were entered.

Please make a copy of your document and practise on the copy. If you Replace All, it will do a Replace over the entire document!


Regards,

Ian.

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.

How do I delete a line break from a spreadsheet in Numbers?

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