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?
|