| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
extract numbers from cell containing text & numbers
Any formula I can use to extract the phone extension from this cell
which contains both Department & extension in a cell e.g Gift Collection 7709 Thxs |
|
#2
|
|||
|
|||
|
extract numbers from cell containing text & numbers
Hi!
Based on that single example: =RIGHT(A1,4) Are all the extensions 4 digits? Are the extensions always at the end? If not, post more representative samples. Biff wrote in message oups.com... Any formula I can use to extract the phone extension from this cell which contains both Department & extension in a cell e.g Gift Collection 7709 Thxs |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Change CSV-load cell format from GENERAL to TEXT for numbers? | Excel Discussion (Misc queries) | |||
| Making calendar with numbers and text in same cell | Excel Discussion (Misc queries) | |||
| Help inserting a Cell Value in a Text Cell | Excel Worksheet Functions | |||
| Autofitting a row | Excel Discussion (Misc queries) | |||
| Cell set to wrap text and blank line -- fix? | Excel Discussion (Misc queries) | |||
Linear Mode
