Hi I want to create a macro that searches a column for a specific criteria, it will then check the portion being replaced if it contains either "Apt", "Suite", or "Floor"
before replacing it.
For Ex if I were to Find "*West" and replace with "", I want it to be able to check to see if "Suite" is in the portion being replaced before replacing it, and if it is then dont replace:
A1) 123 Fake Street West Apt 1
A2) 234 Random Street Suite 3 West
A3) 333 Excel Ave West Floor 3
Result should be the following.
b1) Apt 1
b2) 234 Random Street Suite 3 West
b3) Floor 3
any ideas?
thanks!
Bookmarks