View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
dfresh34 dfresh34 is offline
external usenet poster
 
Posts: 5
Default Search and Replace end of Line and Insert Alt-Enter

I am trying to do a search and replace. I have one column that contains
cells with a lot of text. I want to insert an Alt-Enter at the end of the
line of text in each cell in that column. I know to replace with Alt0010 to
achieve the replace part, but I don't know what to search for. It is not
like in Word where you can search for the paragraph mark at the end of the
line.

I have a massive document and otherwise would have to go line by line.
Thanks for any help.