Remove everything apart from date in cells

[Omer Simpsun]

Hi

I have a range of cells which contain dates in the format dd/mm/yyyy plus a bunch of other text.
I'm looking for a way to remove everything apart from the date so that the cell can be used in a formula.

Thinking maybe regex would be a good way but not sure where to start.

Don't need to validate the date so a text match would work.

[Pepe Le Mokko]

There are instructions at the top of the page on how to post a sample sheet.Thanks

[JEC.]

Formula based

Please Login or Register  to view this content.

Regex Based

Please Login or Register  to view this content.

Or

Please Login or Register  to view this content.

To convert directly to a date (you may don't need DateValue, since I have different regional settings)

Please Login or Register  to view this content.

[Sintek]

I have a range of cells which contain dates in the format dd/mm/yyyy plus a bunch of other text.
I'm looking for a way to remove everything apart from the date

Is it date in some cells and text in others
A1 = 05/01/2022
A2 = Text

Please Login or Register  to view this content.

Or is it date and text combined in cells...
A1 = 05/01/2022Text
A2 = 05/01/2022OtherText

Please Login or Register  to view this content.

Change red snippets above to your range...

[Omer Simpsun]

Thanks for the replies. All work well.
It's for date and text combined in cells.

In the end I went with the formula, but noticed that some dates were like ##/##/##, so modified it slightly to this.

Please Login or Register  to view this content.