How to split columns with multiple lines w/in cells
I have complete addresses in each cell. For example, cell A1 has:
John Smith
123 Main St
Anytown, XX 12345
All lines of data are contained within a single cell. How can I split it so
I have the first line (John Smith) copied to cell B1, line 2 to C1, and line
3 to D1? I am trying to avoid the manual copy/paste method.
Thanks for any advice!
|