=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


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.