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

[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.

 

[Bernard Liengme]

Try this:
=MID(A1,FIND(" ",A1,FIND(":",A1,FIND(":",A1)+1))+1,20)
best wishes

 

[Don Guillett]

If really at date, Just format it as "mmm yyyy"or use a formula in the next
column

 

[Glenn]

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.

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

 

[Teethless mama]

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

 

[SV]

Thanks, for your help. It worked.

Try this:
=MID(A1,FIND(" ",A1,FIND(":",A1,FIND(":",A1)+1))+1,20)
best wishes
--
Bernard Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme




.

 

[SV]

Thanks, Glenn. Your formula worked also.


SV

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

 

[SV]

Thanks, for your help. Your formula worked

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