help commas before data

J

James

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
 
G

Gordon

James wrote:
|| 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

Find ' replace "nothing" (and I mean nothing - leave the Replace field
blank)
 
G

Gate

use the 'copy' then 'values only' for the entire column after you have
cleaned the column
 
Top