I have an excel doc with multiple addresses, and some of them are in the form:
312 Main St. Suite 6
1234 Victoria St PO Box 231
12 Amherst Rd Unit 3
What I want to do is if the addresses contain either Suite, PO Box, or Unit, I want to remove it from the current column and put it into the column next to it. How do I go about doing this in Excel?
I also posted the question in another forum (Excel General) because I wasn't sure where to post it.
Bookmarks