Remove Line Breaks ALT + ENTER

H

Highman

Hi,

I' have a sheet with thousands of extra line breaks. In order to import thsi
sheet I would love to remove all these line breaks automatically. How do I do
this?
 
H

Highman

Thanks for your speedy reply!

My problem is the line break itself. Using your excellent tool tranforms the
characters back into line breaks in Excel. But I would love to get rid of teh
line break alltogether.

What can I do?

Thanks in advance for your help!
 
B

bj

try <edit><find and replace>
just enter alt enter in the find and space or whatever in the replace
(At least works for me in 2002 XL)
 
G

Gord Dibben

Highman

After import you could try Edit>Replace

what: ALT + 0010(or 0013).....use the numpad to enter the 0010

with: nothing

Replace all.


Gord Dibben Excel MVP
 
Top