Hi Stephanie
With your value in cell A1, then
=MID(A1,FIND(",",A1)+2,FIND("^",SUBSTITUTE(A1,",", "^",2))+6-(FIND(",",A1)+2))
--
Regards
Roger Govier
"Stephanie" wrote in message
...
Hi- I have a system that downloads into Excel a timestamp in this format:
Thursday, December 31, 2009 8:00:59 AM
however, this is not a date field but rather a general field so that I
can't
use formatting to get to
December 31, 2009
I'd appreciate suggestions for stripping it down. Thanks.
__________ Information from ESET Smart Security, version of virus
signature database 4751 (20100107) __________
The message was checked by ESET Smart Security.
http://www.eset.com
__________ Information from ESET Smart Security, version of virus signature database 4751 (20100107) __________
The message was checked by ESET Smart Security.
http://www.eset.com