Search and Replace end of Line and Insert Alt-Enter

[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.

 

[vezerid]

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

 

[Guest]

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.