Convert Text To Number

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!
 
P

Per Jessen

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
 
G

Gary''s Student

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

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

Export the values in column B
 
A

Antney

Perfect! Thank you!!

Per Jessen said:
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
Click to expand...
 

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

Convert Numbers to Text 4
Numbers stored as text 4
Windows 7 I need to convert date to text 3
Convert Text to Number 1
Excel Convert word into numbers and back 4
convert to text problem 2
Format Text to Number 2
Convert Numbers stored as Text to Numbers 2

Top