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"
Yes, that's just an idea. If you share in which exactly form and format you'd like to have the result it'll be easy with concrete suggestion.