Extract Date from text

S

sabineb

Hello
I have a cell that reads:

Week Ending:June 02, 2012

and I need to extract the date a June 02 (format 'mmm d') into anothe
cell.

Can anyone tell me how?

Thanks for the help
Sabin
 
R

Ron Rosenfeld

Hello
I have a cell that reads:

Week Ending:June 02, 2012

and I need to extract the date a June 02 (format 'mmm d') into another
cell.

Can anyone tell me how?

Thanks for the help
Sabine
Click to expand...

To extract that number as a"real" date, where you can format the cell however you want:

=--TRIM(MID(A1,FIND(":",A1)+1,20))

To do the same, but return a text string (not a "real" date) of mmm d format, use:

=TEXT(--TRIM(MID(A1,FIND(":",A1)+1,20)),"mmm d")
 
S

sabineb

To extract that number as a"real" date, where you can format the cel
however you want:

=--TRIM(MID(A1,FIND(":",A1)+1,20))






Thanks so much this one did the trick

Sabin
 
Top