Can I replace line breaks in Excel 2003?


G

Guest

I know it is possible in Word but it doesn't seem to work in Excel unless
there is a special trick. I want to replace all line breaks in Excel which
were inserted by holding the Alt key and pressing Enter.

Under the option Edit - Find & Replace I do not find any option to replace
the line break with a space.

Any ideas?

Nicole
 
Ad

Advertisements

D

Debra Dalgleish

In Excel, choose Edit>Replace
Click in the Find What box
Hold the Alt key, and (on the number keypad), type 0010
This represents a line break in Excel.
You won't see anything in the 'Find What' box

In the Replace with box, type the characters that you want to use
instead of a line break

Click the Replace All button
 
Ad

Advertisements

Joined
Aug 4, 2010
Messages
2
Reaction score
0
Debra Dalgleish said:
In Excel, choose Edit>Replace
Click in the Find What box
Hold the Alt key, and (on the number keypad), type 0010
This represents a line break in Excel.
You won't see anything in the 'Find What' box

In the Replace with box, type the characters that you want to use
instead of a line break

Click the Replace All button

Nicole wrote:
> I know it is possible in Word but it doesn't seem to work in Excel unless
> there is a special trick. I want to replace all line breaks in Excel which
> were inserted by holding the Alt key and pressing Enter.
>
> Under the option Edit - Find & Replace I do not find any option to replace
> the line break with a space.


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

thanks
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top