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?

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?

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?