Date formatting

[Stephanie]

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.

 

[Roger Govier]

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

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