View Single Post
  #8   Report Post  
Posted to microsoft.public.excel.worksheet.functions
SV[_2_] SV[_2_] is offline
external usenet poster
 
Posts: 5
Default How do you extract day/time/month/year information

Thanks, for your help. Your formula worked :)

"Teethless mama" wrote:

=MID(A1,FIND(":",A1)+7,99)


"SV" wrote:

Hello,

I came across this issue, where I have a exported excel file. With the
information in a field "Friday 02:15:00 March 2009". I need these
information extracted. I only require Month/Year. I need to end up with a
field with only "March 2009". Is there a formula for this?


Thanks for your help.