The feature you are looking for is called Text to Columns. Just select the
cell(s) and pull-down:

Data Text to Columns... and let the Wizard guide you.

Good Luck
--
Gary's Student


"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