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