Looking for help with slightly advanced delimiting & text to columns.

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!