ReGex

[BRRLL99]

Hi Team,

I have following data(Sheet 1) :

Requirements:

All values which are in yyyymmdd/yyyy-mm-dd shold be in a single seperate coloumn and should be in format yyyymmdd

If there are 2 dates, it shold take the min values

If there are no values, then it should be blank

$ shold be removed.

Data and sample output has been uploaded

[FrederikE · Accepted solution]

Hey @BRRLL99,

Needed a bit more then just regex, but works now 😊.

[Christina_H · Accepted solution]

Here's my version.