In series of 10 digit #s, how can I exclude 1st 3 digits in each?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a series of 900 ten digit numbers. All of the numbers start with the
same 3 digits and I need to omit those (leaving just the last 7 digits). Can
this be done without have to manually delete the 1st 3 digits on each?

I appreciate you taking the time to read this and your assistance.
 
=RIGHT(A1,7) if you want them as text
=--RIGHT(A1,7) if you want them as numbers
 
Thanks for your help David. Both of the formulas were exactly what I was
looking for. I appreciate your help.
 

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

How can I have Excel determine what the last digit is in a series? 2
each number in cell should be 10 digit 2
adding digits of a number 8
Barcode Check Digits 3
Validation of UK VAT Number 20
How do I calculate age using a 12 digit social security number in MS Excel? 0
How do I calculate a check-digit in Excel? 5
//sk - Max length of a numeric field. 4

Back
Top