troubleshooting Question

Excel Extract data from multiline cell

Avatar of Eirejp
EirejpFlag for Japan asked on
Microsoft OfficeMicrosoft ExcelSpreadsheets
10 Comments1 Solution599 ViewsLast Modified:
Hi All,

The software I use outputs the data like below in a single cell.
username 2/6/12 13:00 14:15 01:15 UAT, backup config, warranty cleanup and installation of KB/mouse for bob amongst other tasks.
username 2/6/12 10:15 12:00 01:45 UAT, backup config, warranty cleanup and installation of KB/mouse for bob amongst other tasks.
Total: 03:00

There could be quite a few lines in the cell so I am want to know if it is possible to extract the data into their own cells
e.g.[date ][time][Description] of each line into separate cells for each line? Then the total in its own cell.

I was able to get the total into its own cell by using
=MID(B6,FIND("Total:",B6)+6,6)

Maybe this picture would better explain it what I am after.
Example
Looking forward to your help.

Thanks!
Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 1 Answer and 10 Comments.
Join the Community
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 10 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros