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