Replacing a hard line break in Excel

[Guest]

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.

 

[vezerid]

=SUBSTITUTE(A2,CHAR(10)," ")

This will replace hard break with a space. If you want it completely
wiped out use "" instead of " ".

HTH
Kostis Vezerides

 

[Guest]

When I try to paste this code into the cell, it wipes out what's in the
entire cell. If I try to paste this code into the find and replace, it
doesn't allow me to. Am I doing this wrong?

Thanks.

 

[Dave Peterson]

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.

 

[Guest]

That worked, thank you.

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.