G
Guest
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.
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.