| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Removing house numbers from addresses
I have a spreadsheet containing 18,000 addresses. In some cases the first line of the address (in Column A) contains a house number e.g.
25 High Street 124 Cherry Ave 7 King St In other cases, the address contains no house number e.g. Highgrove Summerseat Is there any way of writing the address line 1 to a new column and deleting the house numbers from any addresses that have one? So in the examples above I would like to end up with the following in the new column: High Street Cherry Ave King St Highgrove Summerset |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Count and Sum Total occurrances of two specific numbers | Excel Worksheet Functions | |||
| Using Macro to Sort Names, Numbers & addresses | Excel Worksheet Functions | |||
| Converting Numbers to Text properly | Excel Discussion (Misc queries) | |||
| removing firsts two numbers from a list of #s | Excel Worksheet Functions | |||
| How to Replace numbers and text with numbers only? | Excel Worksheet Functions | |||
Threaded Mode
