Rick,
Nice one
'---
Jim Cone


"Rick Rothstein"

wrote in message
...
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)