Can I replace line breaks in Excel 2003?

  • Thread starter Thread starter Guest
  • Start date Start date
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
 
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
 
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
Click to expand...

thanks
 
Back
Top