Hi and thanks in advance,
We have tried various methods but cannot find what we are looking for. If we can find someone who shows ability to help us run macros and formulas for us we may look at paying for future data work as we have MUCH data and ongoing data work coming our way!
Example Rows:
195 Testing Road, Great Bay, Auckland
8963 More Tests Road, Browns Bay, Auckland
Fox Street, Excellent Area, Great City
37 Great Tests Avenue, Burnside, Christchurch
Great Barrier Island, Auckland
We need to remove the words "road, street, avenue" and various other words and everything that appears before them (which I have put in bold in example) so we are left with only the "suburbs & cities" which I have made blue in the example.
End result for above example should be:
Great Bay, Auckland
Browns Bay, Auckland
Excellent Area, Great City
Burnside, Christchurch
Great Barrier Island, Auckland
Kindest Regards