Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
In series of 10 digit #s, how can I exclude 1st 3 digits in each?
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
In series of 10 digit #s, how can I exclude 1st 3 digits in each?
=RIGHT(A1,7) if you want them as text
=--RIGHT(A1,7) if you want them as numbers -- David Biddulph "readystate" wrote in message ... 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. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
In series of 10 digit #s, how can I exclude 1st 3 digits in ea
Thanks for your help David. Both of the formulas were exactly what I was
looking for. I appreciate your help. "David Biddulph" wrote: =RIGHT(A1,7) if you want them as text =--RIGHT(A1,7) if you want them as numbers -- David Biddulph "readystate" wrote in message ... 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. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
In series of 10 digit #s, how can I exclude 1st 3 digits in each?
=MID(A1,4,7)+0
"readystate" wrote: 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I sort the last 3 digits first and then the first 4 digit?. | Excel Worksheet Functions | |||
How do I shorten 10-digit # so only 6 digits show up? | Excel Discussion (Misc queries) | |||
Getting the first 3 digits out of 6 digit cells? | Excel Worksheet Functions | |||
Why is Excel changing the last 2 digits of a 17 digit num to 00. | Excel Discussion (Misc queries) | |||
I have a col. with 6 digit nos to convert to 3 cols of 2 digits | Excel Discussion (Misc queries) |