[Solved] Find and Replace question

[RusselB]

I recently imported a table from a website, and have discovered that the character generated by CHAR(10) is used in place of the space at certain points.
I tried to copy the character from the table in order to do a Find and Replace, but the character isn't pasting into the Find box.
I determined the character code using a combination of CODE and MID, so the 10 is the code being returned by Calc.
Is there a way to do a Find and Replace for this (wanting to replace the 10 code character with a space), or do I have to go through the table and manually do it one at a time?

[RoryOF]

Try Find \n Replace <space>, more options Regular Expressions. I'm not certain this will work.

[RusselB]

It works.