This is in Excel 2016 (I think that's the version)
I think this might have to be done with VBA but if I can avoid it I'd like to, only because I don't have a lot of VBA experience.
I'm trying to figure out how to split addresses into a few specific columns, and I'm having some trouble figuring out exactly how to do that.
The addresses are almost always like this:
100 Street Name BLVD City, STATE 00000 (state is two letter abbreviation, CA/AZ/NV etc)
the columns I need are "100 Street Name BLVD" "City" "STATE" and "0000". If i set it to delimit by space and comma then it almost works except that splits the whole street address. In theory I think I'd want it to delimit after a series of capital letters (that should handle BLVD and any smaller permutations of it like ST/RD/CIR, without hitting capital letters in street names). There's also the added problem of City names that have a space in them, so I might need to somehow make an exception or make it not start a new column until it hits ", "
I'm not super sure how to actually do that, though, so any advice is appreciated. Thanks!
Bookmarks