How do you extract day/time/month/year information

  • Thread starter Thread starter SV
  • Start date Start date
S

SV

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.
 
Try this:
=MID(A1,FIND(" ",A1,FIND(":",A1,FIND(":",A1)+1))+1,20)
best wishes
 
If really at date, Just format it as "mmm yyyy"or use a formula in the next
column
 
SV said:
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.
Click to expand...


=TRIM(RIGHT(SUBSTITUTE(A1," ",REPT(" ",100)),200))
 
Back
Top