Forum Discussion
Solved
Convert Text to Cell
Hi i have in a cell a Multiple Line Text - what i want to split in columns "Start Time (UTC): 8/8/2022 11:58:26 AM
End Time (UTC): 8/8/2022 12:49:08 PM
Duration: 00:50:42.5186092
[8/8/...
Please checked attached in next sheet. I queried sample table in first sheet without manually added columns.
This is what I get if I copy your example into a cell and apply Text to Columns with Ctrl+J as delimiter:
Perhaps your data actually have a different delimiter?
Could you attach a sample workbook (without sensitive data), or if that is not possible, make it available through OneDrive, Google Drive, Dropbox or similar? Thanks in advance.
HansVogelaar
strange... ok, i attached a 3 line CSV- i think PQ is a idea, but to much - but i will check your solution. but "new in PQ"
