Replacing a hard line break in Excel
 

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.

Replacing a hard line break in Excel
 

=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.

Replacing a hard line break in Excel
 

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.

"vezerid" wrote:

=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.

Replacing a hard line break in Excel
 

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

Replacing a hard line break in Excel
 

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