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.
Thank you, very close but this doesn't separate the end of the Payroll ID number from the 2nd FName
"11111FName LName: Custom Identifier"
This is the field when un-wrapped:
FName LName: Custom Identifier/External Payroll ID/11111FName LName: Custom Identifier/Personal Identification Number/9999999
"11111FName LName: Custom Identifier"
This is the field when un-wrapped:
FName LName: Custom Identifier/External Payroll ID/11111FName LName: Custom Identifier/Personal Identification Number/9999999
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.
- That works, thank you so much!