how to replace a hard return?
 

I have a bunch of hard returns at least I think that is what they are. The
data comes from a database on our intranet. I get the data in the form of an
excel spreadsheet. But now I have all of the returns. They look like bold
bars and when I click in the cell they look like empty boxes. I tried doing a
find and replace with ALT 0010. It found a number of returns but not any of
the ones I need it to find.

If you can help I would appreciate it very much.

how to replace a hard return?
 

let's say that this is the 4th character in the string in A1. In another
cell you could do

=code(mid(A1,4,1))

to find out what the ascii code of the character is.

--
Regards,
Tom Ogilvy



"go1angel" wrote in message
...
I have a bunch of hard returns at least I think that is what they are.
The
data comes from a database on our intranet. I get the data in the form of
an
excel spreadsheet. But now I have all of the returns. They look like bold
bars and when I click in the cell they look like empty boxes. I tried
doing a
find and replace with ALT 0010. It found a number of returns but not any
of
the ones I need it to find.

If you can help I would appreciate it very much.