| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Extracting # numbers from address
I trying to extract the unit numbers from an address which have the unit
number all over and then clearing the extracted #unit from the original column. Any easier formula? e.g 123 Albert St #01-01 #02-112 St James St 12 Tomlinson Rd #01-01/02 George Bldg #10-01-03 Smith St -- KH |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Extracting numbers from a cell | Excel Discussion (Misc queries) | |||
| Checking Winning Numbers in the Lottery. | Excel Discussion (Misc queries) | |||
| 2 more questions about extracting numbers from text strings | Excel Discussion (Misc queries) | |||
| extracting numbers from string | Excel Discussion (Misc queries) | |||
| extracting numbers with no more than 8-digits using advanced filtering | Excel Worksheet Functions | |||
Threaded Mode
