nyrangers1994
New Member
- Joined
- Aug 30, 2011
- Messages
- 17
I have an Excel Table (ListObject) that has a column called "Location" and it's in column M. It has values such as New York Metropolitan Area (New York, NY). I need a macro that looks in this column and deletes anything that isn't within the parentheses, including the parentheses themselves, such that the columns undergo these types of transformations:
1. New York Metropolitan Area (New York, NY) --> New York, NY
2. (Boston, MA) Boston Metropolitan Area --> Boston, MA
3. Philadelphia Metropolitan (Philadelphia, PA) Area --> Philadelphia, PA
Thanks for any help anyone can provide.
1. New York Metropolitan Area (New York, NY) --> New York, NY
2. (Boston, MA) Boston Metropolitan Area --> Boston, MA
3. Philadelphia Metropolitan (Philadelphia, PA) Area --> Philadelphia, PA
Thanks for any help anyone can provide.