Ok, i have these tick marks (they're comma's) in every cell before my data,
for example '27458, '33354

I can't get a vlookup to work unless i get rid of the comma's. the problem
is i have 28000 rows to fix. Any ideas?

I'm using Excel 2000.

TIA

James