[Solved] Need help removing manual line breaks in cell

[RonR1965]

Have a page of data that I copy and pasted from the internet into calc. I have a couple columns that have text with manual line breaks in them and I need to remove them. have tried find & replace but don't know how to find the page break. This is driving me nuts.

[MrProgrammer]

Hi, and welcome to the forum.

have a couple columns that have text with manual line breaks in them and I need to remove them.

Edit → Find & Replace → More Options → ✓ Regular Expressions → Search for → \n → Replace with → {YourChoiceForReplacement}

Remember that you can use Edit → Undo if the replace operation creates unexpected results.

If this solved your problem please go to your first post use the Edit button and add [Solved] to the start of the title. You can select the green checkmark icon at the same time.

[RonR1965]

Thank you so much. You saved me weeks of work.