From Multi-line to single cells

I have a spreadsheet with address like this:

Cell A1
123 maine street
city, st, 02345

I would like some how to convert it to:

Cell A10..............| Cell B10...| Cell C10..| Cell D10
123 maine street..| City..........| st............| 02344

Any ideas ... there are 600 entries, so I don't want to do it manually
I have Excell 2011 Mac Os

Thank you

this should do it:

Please Login or Register  to view this content.

This assumes all of your data is in the A column and starts on Sheet1 at cell A1. Adjust as needed.