Problem with line breaks.
How to remove line breaks in Number? or even excel in Mac?
How to remove line breaks in Number? or even excel in Mac?
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.
Line breaks where? Can you post a screenshot (shift-command-4, use crosshairs to select area, release, then start a new post here and insert the image file from the Desktop using the "mountains and moon" insert image icon below the compose window._
SG
"<p" and "</p> are the delimiters of paragraphs (instead of a new line).
You could replace these delimiters with null strings or remove them all together.
Paul.
Thank you for reply. I really need help. I'm working on a spreadsheet which all data in each cell must be in 1 line. So I can say each cell in description column.
What do you expect to display in (for example) the cell below the cell containing "Description" in your screenshot?
Regards,
Barry
Each cell in description column must be just in 1 line.
Thanks
Problem with line breaks.