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.
PaddyB The PQ solution provided by SergeiBaklan made me realize that you perhaps wanted a different solution. One that I had otherwise not thought of.
See attached.
thanks for the Idea. this split is more than i need 🙂
would be happy just have the 3 "1st Lines" in a separate cell
for example
Starte Time line in one cell
End Time Line in one cell
Duartion Time in one Cell
end the rest if possible in a last cell
