Convert Text To Number

  • Thread starter Thread starter Antney
  • Start date Start date
A

Antney

I have about 15K id numbers I need to convert from text to number. All of the
id numbers end with _, for example, 106102_. I need to import these id
numbers into Access but I can't convert them in Access and I can't figure out
how to convert them in Excel so that I may import them. Can someone help?
Thanks!
 
Hi

If you have ID numbers in column A enter this formula in B1 and copy down.

=(LEFT(A1,LEN(A1)-1))*1

Regards,
Per
 
Say your values are in column A. In B1 enter:

=--SUBSTITUTE(A1,"_","") and copy down

Export the values in column B
 
Back
Top