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
|