Cell data prefixed with unknown character

[ingineu]

I am trying to work with a column in an Excell Sheet that has numeri
data. The problem is that it appears there are 'spaces' before th
number. I have tried to remove them with the Replace Menu option wit
no luck. I'm thinking that the character may not be a 'space' but som
other character. Is my next step to try to find the Hex value of th
character? If so, how do I go about doing that?
Thanks

 

[Biff]

Hi!

Here's a few things you can try:

1. Try the TRIM() function. This removes leading and
trailing spaces.

2. Try the CLEAN() function. This removes other non-
printable chars like line feeds.

3. If 1 and 2 fail try this macro from David McRitchie:

http://www.mvps.org/dmcritchie/excel/join.htm#trimall

Biff