Hi

Select the cell, then click on Data|Text to Columns, Select delimited and
Space as the delimiter, and Finish
--
ve_2nd_at. Randburg, Gauteng, South Africa


"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