help commas before data

  • Thread starter Thread starter James
  • Start date Start date
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
 
Use the 'Data', 'Text-to-column' feature. It'll do it in one operation.
 
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)
 
use the 'copy' then 'values only' for the entire column after you have
cleaned the column
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Transposing contents of a cell 6
Data Validation or VBA 6
Saving text with commas in a .csv file then converting to a .txt f 3
saving on screen data to comma delimetted text file 0
Problem Opening CSV Files from Web Links 2
Show comma in data validation list? 7
Excel 2002 : How to eliminate _ before a cell address in a formula 1
sorting data after import 2

Back
Top