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)

--
Interim Systems and Management Accounting
Gordon Burgess-Parker
Director
www.gbpcomputing.co.uk