Hello,
Trying to do some advanced find and replace. Would normally use index match, but there's a few reasons I think there may be a better VBA solution.
I have the names of United States Regions in Column A. Sometimes there are multiple regions ... I.e., Cell A5 could say "U.S. Midwest" and...