Hey all!

I just joined today and I'm in need with help for a formula. So what I am doing is that I am exporting my data and when I paste it.

The column has all the following in it:

01/25/2019 11:59 PM PST

I was seeing if there is anyway someone can help with a formula that gets rid of the PST. I haven't gotten anywhere with it and can't find anything.

Thank you!!