Dear Experts,
I need a formula to convert text to date and copy in column A. Below is the data for reference.
<colgroup><col></colgroup><tbody>
<colgroup><col></colgroup><tbody>
<colgroup><col></colgroup><tbody>
15/09/2019(Sunday)
SnoG0111
SnoG014
SnoG018
SnoG020...