I have been attempting to extract the date from a cell. I have tried using the MIN(), FIND(), RIGHT(), and LEFT() functions but have not been successful as my experience is limited with these functions. The premise is simple enough. Lets assume Column-A has alpha-numeric text strings. The strings will not always be the same length but will be composed the same.

A1= ".DIS210127C177.5"
A2 =".TSLA210502P500"
A3= ".SHOP210430C1020"

I would need the following to appear as dates:

B1= "01/27/2021"
B2= "05/02/2021"
B3= "04/30/2021"

I did receive help earlier on extracting other data from these cells....but now I can't seem to get this one to work.....any and all help would be HUGELY appreciated!!!!

Thank you in advance!!

Mike