Formula or Macro to format data

I currently have a spreadsheet that I've imported a string of text copied out of an xps document. When I pasted it, all the data flowed on a single row. So the spreadsheet currently looks like this:

Please Login or Register  to view this content.

My example shows A-X, but the actual data goes all the way through OQ (maybe further with future imports).

The way I want the data to be display is like this:

Please Login or Register  to view this content.

Is there a formula or macro that could do this?