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.
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.
hi
thank you Guys so much, for all you help.
i upload a manually edited version.
- column A to G is how i get i from my CSV import
- i then manually add for testing the column H, I, J
- after it i copied for testing the stuff by hand from column E to H, I, J
Line 2 and 3 are a result what would makes me already happy 🙂
Line 4 and 5 are the ultimate "i can go to weekend and relax" version