Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Extract Month From A Text String
Good Day,
I have a date that I'm pulling from a report that is in a text string format. What i need to be able to do is extract the month from the string so that I can run a script against the month name. The format of the string is as follows. Wednesday, April 14, 2010 Thanks in advance for your help. Sam |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Extract Month From A Text String
Hi,
Maybe this = MID(A1, FIND(" ",A1,1)+1, FIND(" ",A1,FIND(" ",A1,1)+1)-(FIND(" ",A1,FIND(" ",A1,1)))) -- Mike When competing hypotheses are otherwise equal, adopt the hypothesis that introduces the fewest assumptions while still sufficiently answering the question. "George" wrote: Good Day, I have a date that I'm pulling from a report that is in a text string format. What i need to be able to do is extract the month from the string so that I can run a script against the month name. The format of the string is as follows. Wednesday, April 14, 2010 Thanks in advance for your help. Sam |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Extract Month From A Text String
=MID(A1,FIND(",",A1)+2,FIND(" ",A1,FIND(",",A1)+2)-FIND(",",A1)-2)
best wishes -- Bernard Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme "George" wrote in message ... Good Day, I have a date that I'm pulling from a report that is in a text string format. What i need to be able to do is extract the month from the string so that I can run a script against the month name. The format of the string is as follows. Wednesday, April 14, 2010 Thanks in advance for your help. Sam |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Extract Month From A Text String
Hey Guys,
Thanks for the quick response...It's exactly what I needed and works perfectly.. George "Bernard Liengme" wrote: =MID(A1,FIND(",",A1)+2,FIND(" ",A1,FIND(",",A1)+2)-FIND(",",A1)-2) best wishes -- Bernard Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme "George" wrote in message ... Good Day, I have a date that I'm pulling from a report that is in a text string format. What i need to be able to do is extract the month from the string so that I can run a script against the month name. The format of the string is as follows. Wednesday, April 14, 2010 Thanks in advance for your help. Sam |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Extract Month From A Text String
On Tue, 11 May 2010 06:25:01 -0700, George
wrote: Good Day, I have a date that I'm pulling from a report that is in a text string format. What i need to be able to do is extract the month from the string so that I can run a script against the month name. The format of the string is as follows. Wednesday, April 14, 2010 Thanks in advance for your help. Sam Assuming the text string is always the entire contents of the line, and is always formatted as dddd, mmmm dd, yyyy or dddd, mmmm d, yyyy Then =--MID(A1,FIND(",",A1)+2,99) or =DATEVALUE(MID(A1,FIND(",",A1)+2,99)) will return a number which is the Excel Date. (40282 for the above date). You can then extract the month as a number [1-12] using the MONTH worksheet function: =MONTH(--MID(A1,FIND(",",A1)+2,99)) If you want the month as text, then: =TEXT(--MID(A1,FIND(",",A1)+2,99),"mmmm") --ron |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Extract value from a text string | Excel Worksheet Functions | |||
Extract text from a string | Excel Worksheet Functions | |||
Extract text string using MID | Excel Worksheet Functions | |||
Extract text from String | Excel Worksheet Functions | |||
Extract % from text string | Excel Worksheet Functions |