| Home |
| Search |
| Today's Posts |
|
#2
|
|||
|
|||
Formula in B1:
=MID(A1,1,FIND("p: ",A1,1)-2) Formula in C1: =MID(A1,FIND("p: ",A1,1)+3,12) Formula in D1: =RIGHT(A1,12) These formulas rely on the assumption that the cell in column A will always have "p: " and that telephone numbers will always be in ###-###-#### format. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formulas dealing with text data | Excel Worksheet Functions | |||
| Text number to number value for calculating | Excel Worksheet Functions | |||
| Sort or Filter option? | Excel Worksheet Functions | |||
| Formatting a cell as "text" in the number catagory. | Excel Worksheet Functions | |||
| GET.CELL | Excel Worksheet Functions | |||
Threaded Mode
