Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Extracting House Numbers from Street Addresses
How do I extract house numbers from street addresses when the number of
characters varies. For example, one address might be "4 Olde Coach Road," another might be "22 Olde Coach Road" or even "138 Cyber Lane" or even "1452 Digital Drive." At times, there is even the odd "15 L Byte Boulevard." Ultimately, I need to sort my list by street name, and to do so, I need to extract the various leading numbers. Thanks for your help. -- George M. gmfbard AT verizon DOT net |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to House, 123 Street, Somewhere, M1 23X | Excel Discussion (Misc queries) | |||
how do I look for duplicate house addresses in a column in Excel? | Excel Worksheet Functions | |||
TRYING TO ALPHBETIZE STREET ADDRESSES | Excel Discussion (Misc queries) | |||
Help! How to sort addresses by street then by #...... | New Users to Excel | |||
Removing house numbers from addresses | Excel Worksheet Functions |