Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Search and Replace end of Line and Insert Alt-Enter
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 dfresh34 wrote: 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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Search and Replace end of Line and Insert Alt-Enter
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. "vezerid" wrote: 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 dfresh34 wrote: 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Search & Replace to insert alt+ |
Excel Discussion (Misc queries) |