Do, Text to columm to see if there is invisible space in the columm

"Confused" wrote:

I am using vlookup to lookup values in data copied from a CSV file. It first
returned #N/A so i changed the Number Format (of the Lookup_Value) to "Text"
and it still returned #N/A but when i pressed F2 and then enter (on the
Lookup_Value cell), the vlookup returned the correct value.

This is really driving me up the wall, can anyone help?