Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
find/replace enters
is it possible to do a find/replace in excel on paragraph ends etc like in
ms word? Some of the cells in my excel files have multiple lines in 1 cell (it's not that they continue on the following line because of word wrap, no, there must be an enter or something between it. I want to replace those by another character. In ms word I can do this find/replace but not in excel it seems? I don't see those special character options in excel 2003. any suggestions? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
find/replace enters
It is char(10)
Find ALT+0010, Replace with nothing -- Kind regards, Niek Otten "search" wrote in message news:1138736864.91982@bru-ix-srv240... is it possible to do a find/replace in excel on paragraph ends etc like in ms word? Some of the cells in my excel files have multiple lines in 1 cell (it's not that they continue on the following line because of word wrap, no, there must be an enter or something between it. I want to replace those by another character. In ms word I can do this find/replace but not in excel it seems? I don't see those special character options in excel 2003. any suggestions? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
find/replace enters
<Replace with nothing
should of course be Replace with another character -- Kind regards, Niek Otten "Niek Otten" wrote in message ... It is char(10) Find ALT+0010, Replace with nothing -- Kind regards, Niek Otten "search" wrote in message news:1138736864.91982@bru-ix-srv240... is it possible to do a find/replace in excel on paragraph ends etc like in ms word? Some of the cells in my excel files have multiple lines in 1 cell (it's not that they continue on the following line because of word wrap, no, there must be an enter or something between it. I want to replace those by another character. In ms word I can do this find/replace but not in excel it seems? I don't see those special character options in excel 2003. any suggestions? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to find/replace data in column | Excel Discussion (Misc queries) | |||
How to find/replace data in column | New Users to Excel | |||
Find/Replace Text In Cells | Excel Discussion (Misc queries) | |||
How to import a TXT with strings containing enters into Excel? | Excel Discussion (Misc queries) | |||
Find/Replace carriage return & line feed characters in Excel. | Excel Worksheet Functions |