CellView.zip is a free download from www.cpearson.com that actually SHOWS
you exactly what characters are in a cell, visible or not........it's really
good.

Vaya con Dios,
Chuck, CABGx3


"Toby Stevenson" <Toby wrote in message
...
Hi Peo,

Yes I am sure they are carriage returns. =Find(CHAR(10)|G5) return a value
of 8. (| character is currently my list separator)

The problem with using alt 0010 was an artifact of using my laptop
keyboard
which doesn't have a separate number pad, I hooked up an external keyboard
and that solved the problem, but lead to another one. I am now receiving
an
error while trying to do this replace:

"Formula is too long"

Toby

"Peo Sjoblom" wrote:

Are you sure they are carriage returns?

=FIND(CHAR(10),A1)

or

=FIND(CHAR(13),A1)

if both formulas return an error then there must be something else

If you get a number then the replace must be done incorrectly make sure
that
match entire cell contents is not checked under options and type either
010
or 0010
However, I have noticed sometimes that excel can't find a character that
I
know is there and then if I close Excel, start again it will work

regards,

Peo Sjoblom