I have several hundered single column addresses I need to break down into multiple columns, including ADDRESS, CITY, STATE, ZIP.

The addresses are all single column, and look like this:

2100 Wescott Dr,*Flemington,*NJ*08822»*Get Directions
865 Stone St,*Rahway,*NJ*07065»*Get Directions
355 Bard Ave,*Staten Island,*NY*10310»*Get Directions

I've experimented with =Left( =Right( =Mid( but cannot figure out how to retrieve the data in separate columns as needed.

Can anyone provide some guidance?
Thanks