How can I split the contents of a cell across multiple cells. I tried using
the Text to Columns option in Excel which works, but I have over 200 cells
that need to be corrected. The data in the cell appears as:

John Public
123 Main Street
Anytown, State 00000

I need to appear as:

John Public 123 Main Street Anytown State 00000

Any suggestions would be appreciated.