Hi Jim, thanks for your reply. It's actually just purely text.
There's absolutely nothing behind it right now unfortunately.

Assuming you do not have to convert that date/time to another time zone,
select the entire column (or column) of dates, press CTRL+H to bring up the
Replace dialog box, type this...

" PST*"

(without the quote marks)(notice the leading space) into the "Find what"
field and make sure the "Replace with" field is completely empty, then press
the "Options" button and make sure the "Match entire cell contents"
checkbox is NOT checked, then click the "Replace All" button and your values
should all get changed to real time/date values (which you can "cell format"
to look however you want).

Rick Rothstein (MVP - Excel)