Here's a couple of functions to get you started...

City: =LEFT(A1,SEARCH(",",A1,1)-1)
State: =MID(A1,SEARCH(",",A1,1)+2,2)
Zip: =RIGHT(A1,5) 'if only 5 characters

hth
James

"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