Forum Discussion
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/2022 11:58:26 AM (UTC)] xxx@xxx joined.
[8/8/2022 12:26:00 PM (UTC)] xxx@xxx left.
[8/8/2022 11:59:41 AM (UTC)] xxx@xxx joined.
[8/8/2022 12:49:08 PM (UTC)] xxx@xxx left."
i test it with "Text to column" function and as a delimiter "CTRL + J" - it takes the first line, that's it.
for me, the solution would be if i just can Splitt the first 3 lines to separate 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.5186092any idea for a absolutely NO Excel Guy?
Please checked attached in next sheet. I queried sample table in first sheet without manually added columns.
14 Replies
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
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
