How to separate address now in 1 cell into 4 cells

Can someone help me break complete address, all in 1 cell, into Address, City, State and Zip into separate cells ? Each value is separated by a comma, except for the 5 digit zip code at the end that only has a space separating the zip from the state.

SAMPLE ADDRESS:

1387 W. Francis St., Ontario, Ca. 91762

Thanks in advance.

Hi Matt,

If that address is in A1, select A1 and use Data -> Text To Columns.
Select Delimited and click Next.
Check the box next to Comma and click Next.
Click Finish.

That will put everything into 3 cells (A1:C1). In D1 use the formula

=LEFT(C1,FIND(" ",C1)-1)

In E1 use the formula

=RIGHT(C1,5)

Copy D1 and E1, then right-click on C1 and use PasteSpecial -> Values. (You can then delete E1.)

A macro could do this as well, if you have many rows to adjust.