That worked, thank you.

"Dave Peterson" wrote:

This may work:

Select the range to fix
Edit|replace
what: ctrl-j
with: (spacebar) (or whatever you want)
replace all.

This edit|Replace will fail on cells that have lots and lots of characters,
though.

a_ryan1972 wrote:

Hi,
I have a pretty large spreadsheet. The person that originally created it
didn't know how to use word wrap so they inserted hard breaks in cells to get
it to wrap. Now, I want to get rid of this. How can I replace a hard break?

Thank you.

--

Dave Peterson