Forum Discussion
Solved
Split data in a single cell
How can I split data in a single cell when there isn't a clear data separation point? I need to separate the two lines into columns. The source data format cannot be changed. I cannot figure out a ...
I thought there were 2 cells.
Try Text to Columns with Delimited as type.
Tick the Other check box and press Ctrl+J in the box next to it. This is the code for a line break.
If there are spaces, those can be delimiters; if there's a colon, that can be a delimiter. Can you post a copy (after eliminating identifiable names) on OneDrive or GoogleDrive with a link here that grants access?