Extract date from text

[dpetter]

Hi Guys,

could you help me with formula to get date from text as below ?

from text: 30.5.2019 19:24
to this date format: 30-05-2019 7:24:00 PM

Thanks a lot.

 

[jasonb75]

Try using find and replace (ctrl h) to change . to /
Then change the cell format as needed.

 

[dpetter]

Hi Jason,

So simple and I have been looking for a formula..learning every day

Thanks a lot and have a good day.