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