I have a large data set of info in one column that I need separated into multiple columns. Can't use the "Text to Columns" tool because the text is not delimited nor fixed. Here is an example of some of the cells:
"Mary R. Anderson1865 W Choke Cherry DriveLouisville CO 80027"
"Sandy Andrews801 Meadowlark CoveLafayette CO 80026"
"Vujka ""VaVa"" S. Andrick4559 Beechcomber CourtBoulder CO 80301"
"Gaynel K. Andrusko3178 Eastwood CourtBoulder CO 80304"

I need these separated into columns for first name, last name, address, city, state, zip

Help!