Getting rid of '

S

Sue

I received a file that contains manufactuerer numbers and I am working with
VLOOKUP functionality. The ones with only numbers are read as a number and I
have no problems. The mfr numbers w/ alpha-numeric or hyphens are coming to
me with a ' preceding the number. This is preventing me from doing a
VLOOKUP. I am looking for advice on the best/easiest way to eliminate the '
w/o having to do it line by line (file has 10,000 lines). I use Excel 2003.

Thanks,
Sue
 
M

Mike H

Sue,

This should get rid of them. Right click the sheet tab, view code and paste
this in and run it.

Sub mariner()
Set myrange = ActiveSheet.UsedRange
For Each c In myrange
c.Formula = c.Formula
Next
End Sub

Mike
 
S

Sue

Mike,
Thank so yo uso much, the code worked like a charm. Those little
apostrophe's have been driving me crazy! I will pass on to others and again
I appreciate the help!

Take care,
Sue
 
S

smayr

Mike you are wonderful. I had exported my contacts from outlook into an excel
spreadsheet and every field had the leading '. The code worked like a charm
for getting rid of them. Thank you, thank you, Thank you!
 
Top