Use the 'Data', 'Text-to-column' feature. It'll do it in one operation.
--
HansM

"James" wrote in message
...
sorry, i meant apostrophes
"James" wrote in message
...
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