Hidden characters-saving a file to excel

[macke]

On a website I use I am given the option of saving a file to excel. When I do and attempt a vlookup against the first column containing 6098765 it fails. On selecting the cell in the vlookup it appears as " 6098765" It is obvious that the vlookup fails because of the hidden quote marks and space. I have tried trim and clear and value, but none will clear them. I know I could use substitute, but I don't know what the characters are.

Can anyone help.

Macke

[NBVC]

To find out the character try something like =Code(left(A1,1)) or =Code(Mid(A1,2,1)) if it is second character... it probably is 016