| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
last number array from string
I have a address string (variable length) with ID numbers at the end and want
to be able to identify just the array at the end which could be any number in length example Pharma-e,, ,Albert House, South Esplanade, Guernsey, Channel Islands, ,GY1 1AN ,(01481 736 736), ,Pharmacy, , ,202268 as I want to use the number for a lookup, please can anyone help with a formula as there are 12,000 records. Thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Need number of Saturdays and number of Sundays between 2 dates | Excel Worksheet Functions | |||
| How can I assign a number to a string? | Excel Discussion (Misc queries) | |||
| Random Number Questions | Excel Worksheet Functions | |||
| How to format a number in Indian style in Excel? | Excel Discussion (Misc queries) | |||
| Extending a Chart Data Series from an Array - Can it be done? | Charts and Charting in Excel | |||
Threaded Mode
