Hi All
I'm looking for a formula which might help solve a problem I'm having with some data.
In my spreadsheet I have a column of dates, however, within the same cell, some text can also appear.
EXAMPLE: 01/01/2017 CGHS
Is there a formula I can use to strip out the letters and leave behind just the numbers and the / character?
Thanks in advance.
EDIT:
There can sometimes be two dates within the same cell and the letters are not always fixed in the same place.
Attempted some VBA functions but one stripped out everything except numbers, which ruined the date format.
Bookmarks