Hi,
I hope someone can help, I need to be able to trim a list of address I have in say column A, so that any unit numbers, or levels are removed and am left with just the building number and street name, and have this returned into another column.
Examples:
lvl 24 105 example st ----> 105 example st
unit 12, lot 5 example rd ---> 5 example rd
4/33 example ave ----> 33 example ave
123 example st ----> 123 example st
I've tried functions like RIGHT, ISNUMBER and MATCH to try and have it search from the right to the nearest number and then return everything to the right, but haven't succeeded.
Any help is appreciated.
Bookmarks