Date formatting

  • Thread starter Thread starter Stephanie
  • Start date Start date
S

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.
 
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 said:
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
Click to expand...

__________ Information from ESET Smart Security, version of virus signature database 4751 (20100107) __________

The message was checked by ESET Smart Security.

http://www.eset.com
 
Back
Top