Hi,
Would really appreciate a formula to extract the date in (CELL A2) from the string below, and then have that extracted date returned in lets say (Cell C2) in the format DD/MM/YYYY.
I have lots of these, but the date is always located between the sixth and seventh forward slashes.
Thanks.
Would really appreciate a formula to extract the date in (CELL A2) from the string below, and then have that extracted date returned in lets say (Cell C2) in the format DD/MM/YYYY.
I have lots of these, but the date is always located between the sixth and seventh forward slashes.
Thanks.
2021-01-30/1200/30/1/heed-your-hunch-at-betway-handicap |