jebenexcel
Board Regular
- Joined
- Mar 16, 2018
- Messages
- 59
Hi,
How would one go about getting the last set/word of characters on the right side of a string, delimited by the first space from the right without inserting any new cells?
I need to separate some addresses into street names and house numbers; the numbers are 1-999 but sometimes they are letters as well, so I can't just remove all non-number characters to do that.
How would one go about getting the last set/word of characters on the right side of a string, delimited by the first space from the right without inserting any new cells?
I need to separate some addresses into street names and house numbers; the numbers are 1-999 but sometimes they are letters as well, so I can't just remove all non-number characters to do that.