Home |
Search |
Today's Posts |
|
#1
|
|||
|
|||
removing everything from the left after 10 digits
I have a column of phone numbers. I would like to "strip" off everything
after 10 digits ie1: 5555551212 ie2: 95555551212 ie3: 5551212 ie4: 15555551212 so in columns 2 and 4 I would like to strip off the 9 and 1 I do not have alot of programming exp. thanks for your help |
#2
|
|||
|
|||
The "Right" function would probably be useful for this. Ie =right("Cell
reference",10) Regards, Adam Wood "tri_p" wrote: I have a column of phone numbers. I would like to "strip" off everything after 10 digits ie1: 5555551212 ie2: 95555551212 ie3: 5551212 ie4: 15555551212 so in columns 2 and 4 I would like to strip off the 9 and 1 I do not have alot of programming exp. thanks for your help |
#3
|
|||
|
|||
On Thu, 29 Sep 2005 22:40:02 -0700, "tri_p"
wrote: I have a column of phone numbers. I would like to "strip" off everything after 10 digits ie1: 5555551212 ie2: 95555551212 ie3: 5551212 ie4: 15555551212 so in columns 2 and 4 I would like to strip off the 9 and 1 I do not have alot of programming exp. thanks for your help with phone numbers in column B starting in B1, put in A1 =IF(LEN(B1)<=10,B1,RIGHT(B1,LEN(B1)-(LEN(B1)-10))) HTH __ Richard Buttrey Grappenhall, Cheshire, UK __________________________ |
#4
|
|||
|
|||
That worked PERFECT (which I'm sure you knew that it would)
Thank you so much!!! "Richard Buttrey" wrote: On Thu, 29 Sep 2005 22:40:02 -0700, "tri_p" wrote: I have a column of phone numbers. I would like to "strip" off everything after 10 digits ie1: 5555551212 ie2: 95555551212 ie3: 5551212 ie4: 15555551212 so in columns 2 and 4 I would like to strip off the 9 and 1 I do not have alot of programming exp. thanks for your help with phone numbers in column B starting in B1, put in A1 =IF(LEN(B1)<=10,B1,RIGHT(B1,LEN(B1)-(LEN(B1)-10))) HTH __ Richard Buttrey Grappenhall, Cheshire, UK __________________________ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel should calculate exponentials properly (right to left) | Excel Worksheet Functions | |||
Mod 10 & 11 | Excel Worksheet Functions | |||
help with removing digits from a number | Excel Discussion (Misc queries) | |||
The left function does not work when displaying times, how is thi. | Excel Worksheet Functions | |||
Least number of digits in Y-axis labels | Charts and Charting in Excel |