Hello!
I need help with a project in Excel. I have multiple cells with large amounts of text and numbers. I need to extract the listed identified time and the verified time and then calculate the turnaround time.
Here's an example of the data in the cell:
EXAM: CT Head w/o Contrast
CLINICAL INDICATION: Stroke Protocol;Other.
TECNIQUE: Helical CT images from skull base to vertex without IV contrast.
ESRC.1.1.2
Critical findings were identified on 5/29/2019 7:11 AM, read back and verified with Dr. Smith on 5/29/2019 7:16 AM by Dr. Lu, MD.
The items that are bolded and underlined are what need to be found and extracted. The format of the identified and verified times will always be the same.
Step by step instructions are most helpful so I can teach others!
Thank you in advance!
I need help with a project in Excel. I have multiple cells with large amounts of text and numbers. I need to extract the listed identified time and the verified time and then calculate the turnaround time.
Here's an example of the data in the cell:
EXAM: CT Head w/o Contrast
CLINICAL INDICATION: Stroke Protocol;Other.
TECNIQUE: Helical CT images from skull base to vertex without IV contrast.
ESRC.1.1.2
Critical findings were identified on 5/29/2019 7:11 AM, read back and verified with Dr. Smith on 5/29/2019 7:16 AM by Dr. Lu, MD.
The items that are bolded and underlined are what need to be found and extracted. The format of the identified and verified times will always be the same.
Step by step instructions are most helpful so I can teach others!
Thank you in advance!