help commas before data
 

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

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

check out the CLEAN() function in Excel help.

"James" wrote:

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

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

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

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

"Gate" wrote:

check out the CLEAN() function in Excel help.

"James" wrote:

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