I cant seem to find a formula that works, i have a date in a date time string
21/03/2021 07:03:00
This is in cell A2
I have done the time part of it into another column yet struggling to extract the date to another column, i have tried other suggestions yet nothing seems to be working
the data comes from another source direct to excel and appears to be in custom format
dd/mm/yyyy hh:mm
i wish to have the date as below when extracted
21st March 2021
Thanks in advance
21/03/2021 07:03:00
This is in cell A2
I have done the time part of it into another column yet struggling to extract the date to another column, i have tried other suggestions yet nothing seems to be working
the data comes from another source direct to excel and appears to be in custom format
dd/mm/yyyy hh:mm
i wish to have the date as below when extracted
21st March 2021
Thanks in advance