Using replace to get rid of paragraph return character

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a non-functioning paragraph return symbol at the end of all my text
strings (from info I pulled off the web). ^p in the replace box doesn't get
rid of them. Any ideas?
 
Try Alt+0182 in the find box. (Hold down ALT key, 0182 must be typed from
numeric keypad.) If they are the actual symbol, rather than returns, that
should find them.
 
Do ctrl + H, click in the find what box, hold down alt and type 0160 on the
numeric keypad, release the alt key
leave the replace with box empty and select replace all

--


Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com
(Remove ^^ from email)
 
alt+0182 brought up the return symbol in the find box (great to know, by the
way), but excel doesn't seem to recognize them as such. Is there a copy and
paste function that can be used for the find box? Would they be easier to
get rid of in another program (I've tried Word, no luck)? Thanks
 
I've tried it, but I can't get the copy /paste function to work in the 'find
what' box in either excel or word.
 
I have a similar problem but I need to put the hard paragraph back into the
text which was copied over from Word into Excel. In the Replace with box I've
tried alt 0010, alt 0182, alt 0160 (all on the number pad) but each time I
get an error saying "formula too long." The alt 0182 shows the hard paragraph
symbol but I get the message. The alt 0160 shows a period.
 
See your other post.
I have a similar problem but I need to put the hard paragraph back into the
text which was copied over from Word into Excel. In the Replace with box I've
tried alt 0010, alt 0182, alt 0160 (all on the number pad) but each time I
get an error saying "formula too long." The alt 0182 shows the hard paragraph
symbol but I get the message. The alt 0160 shows a period.
Click to expand...
 
phil

Alt + 0010 in the "replace with" box will give you a CR in the cell.

Must be typed in using the NumPad at right, not the number keys above qwerty.

You don't want Alt 0160.......that is non-breaking space.

Alternative to Alt + 0010 is CTRL j


Gord Dibben MS Excel MVP
 
Back
Top