|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
February 3rd, 2010, 08:40 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. 
|
|
#2
February 3rd, 2010, 08:55 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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.
|
|
#3
February 3rd, 2010, 08:57 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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.
|
|
#4
February 3rd, 2010, 09:14 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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))
|
|
#5
February 3rd, 2010, 10:20 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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.
|
|
#6
February 4th, 2010, 02:08 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. .
|
|
#7
February 4th, 2010, 02:09 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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)) .
|
|
#8
February 4th, 2010, 02:10 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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.
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
