Home Menu

Menu


ExcelBanter » Excel Newsgroups » Excel Worksheet Functions > How do you extract day/time/month/year information
Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
  
Posts: 5
Default 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.
Reply With QuoteReply With Quote
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
  
Posts: 563
Default 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.

Reply With QuoteReply With Quote
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
  
Posts: 1,522
Default 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.

Reply With QuoteReply With Quote
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
  
Posts: 1,240
Default 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))
Reply With QuoteReply With Quote
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
  
Posts: 3,718
Default 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.
Reply With QuoteReply With Quote
  #6   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
  
Posts: 5
Default 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.

.

Reply With QuoteReply With Quote
  #7   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
  
Posts: 5
Default 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))
.

Reply With QuoteReply With Quote
  #8   Report Post  
Posted to microsoft.public.excel.worksheet.functions
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.
Reply With QuoteReply With Quote
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes
Linear Mode Linear Mode

Posting Rules
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Similar Threads
Thread Thread Starter Forum Replies Last Post
count month when date is in day/month/year format ccKennedy Excel Worksheet Functions 6 April 30th 09 03:32 AM
Tell me which "season" (Month/Day through Month/Day) a date(Month/Day/Year) falls in (any year)??? misscrf Excel Discussion (Misc queries) 1 December 14th 07 02:59 PM
trying to get day/month/year froamt while user enters year only RADIOOZ New Users to Excel 3 June 7th 06 05:30 AM
How do I extract the month end value from a daily time series? MTro Excel Discussion (Misc queries) 2 December 24th 05 11:09 AM
How to extract month number from month name PM Excel Discussion (Misc queries) 2 January 19th 05 03:07 PM


All times are GMT +1. The time now is 10:38 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Contact Us ExcelBanter forum home Privacy Statement