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
eesample.xlsx
PDSWSSAsked:
Who is Participating?
 
bearblackConnect With a Mentor Global Program ManagerCommented:
=IFERROR(IF(SEARCH(":",C2)>0,RIGHT(C2,LEN(C2)-SEARCH(":",C2)),C2),C2)

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

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

http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Excel/Q_28351724.html
0
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.