How would I automate the deletion of all text except for the date in the Excel file described below?

I have attached an excel file that contains 3 columns.

In column C - DTE column  some of the dates also contain "All labs obtained on (mm/dd/yyyy):"   In front of the date.  I have a much larger file with many of these types of entrees.

How can I automate the deletion of this text in front of the date so there will only be dates in the cells in the DTE column. thanks
Who is Participating?
bearblackConnect With a Mentor Global Program ManagerCommented:

This needs to be entered into cell D2 then copied to the least row of your data.
PDSWSSAuthor Commented:
Perfect and thank you.  PDSWSS
PDSWSSAuthor Commented:
Worked as requested.
PDSWSSAuthor Commented:
Hi BearBlack,

I just posted another excel question. Thought you may want to try a solution for this one as well -
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.