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

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.

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

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" wrote in message
...
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.

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

If really at date, Just format it as "mmm yyyy"or use a formula in the next
column
--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"SV" wrote in message
...
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.

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

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.


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

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

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

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

Thanks, for your help. It worked. :)

"Bernard Liengme" wrote:

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" wrote in message
...
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.

.

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

Thanks, Glenn. Your formula worked also.


SV



"Glenn" wrote:

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.


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

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.