Convert text date to Excel format

Hi all,

Is there a quick way to convert Thursday, December 3, 2020 11:03:18 AM GMT to dd/mm/yyyy?

Thanks

Mitesh

one possible option - based on UK settings and assuming you always have a time zone etc

B1:
=REPLACE(SUBSTITUTE(LEFT(A1,LEN(A1)-4),",",MID(A1,FIND(",",A1)+1,4),2),1,MIN(INDEX(FIND(ROW($1:$9),$A1&123456789),0))-1,"")+0
where A1 holds your string
format resulting datetime value as per requirements using standard formatting options

XLent, This is perfect!

Thank you.