If you have thousands of them I would dump them into Word. Convert table to
text. replace all commaspace with just comma. shoot I was going to tell
you to replace all spaces with commas but that place commas with town names.
Then convert text back to table and dump it into excel.
For those towns with spaces. it would push the zipcode into a separate
column. Sort by that column and make repairs to that area.

"Tony" wrote:

What is the formula for breaking up the contents of a cell into multiple cells.

A1
Detroit, MI 48089

A1 B2 B3
Detroit MI 48089

Thanks for the help...........

Tony