View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
BoniM BoniM is offline
external usenet poster
 
Posts: 353
Default Using replace to get rid of paragraph return character

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.

"Raku" wrote:

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?