broken keyboard
New Member
- Joined
- Oct 10, 2017
- Messages
- 8
Hi all,
Hoping to find some help on this one! I have a list of thousands of addresses containing numbers and street names, and I'm trying to "shave off" the number (and sometimes, unit name - e.g. 15/A or 64C) from this list in order to isolate the street name. Unfortunately there are no clear delimiters to work with that I can see. Here's a sample of some of the data below:
<tbody>
</tbody>Every address always starts with a number without fail. Any help would be much appreciated!
PS: I'm using Excel 2010 on Windows 8.
Hoping to find some help on this one! I have a list of thousands of addresses containing numbers and street names, and I'm trying to "shave off" the number (and sometimes, unit name - e.g. 15/A or 64C) from this list in order to isolate the street name. Unfortunately there are no clear delimiters to work with that I can see. Here's a sample of some of the data below:
187 Puriri Street
<tbody> </tbody> |
<tbody>
</tbody>
PS: I'm using Excel 2010 on Windows 8.