Search and Replace end of Line and Insert Alt-Enter

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

Guest

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.
 
If you want this done for all cells, what exactly is it you want to
search for?

Formula-wise, you can use:
=A2&CHAR(10)

You can do this in a separate column and then copy the new column and
Edit|Paste Special... Values.

HTH
Kostis Vezerides
 
I want to search for the end of the text in that cell, that way i can insert
a Alt-Enter to allow enough space for all the text to show.
 
Back
Top