extract month from Txt

[howard]

I have text data in col A


I need to extract the month in Col B


I have tried to set up a formula to do this but where the number of characters changes for a particular month, it does not work


It would be appreciated if someone could assist me

Book1
	A	B
1	Description	Month
2	Sales Data for February 2019	February
3	Sales Data for March 2019	March 20
4
Sheet1

Cell Formulas
Range	Formula
B2	=MID(A2,FIND("for",A2)+4,8)
B3	=MID(A3,FIND("for",A3)+4,8)

 

[Fluff]

If all dates are in 2019, you could use
=SUBSTITUTE(MID(A2,FIND("for",A2)+4,100)," 2019","")

 

[AlanY]

try

Book1
	A	B	C	D
1	Description	Month		Month
2	Sales Data for February 2019	February		January
3	Sales Data for March 2019	March		February
4				March
5				April
6				May
7				June
8				July
9				August
10				September
11				October
12				November
13				December
125

Cell Formulas
Range	Formula
B2	=LOOKUP(9.99E+307,SEARCH($D$2:$D$13,A2),$D$2:$D$13)

 

[Fluff]

Alternately
=TRIM(LEFT(SUBSTITUTE(MID(A2,FIND("for",A2)+4,100)," ",REPT(" ",100)),100))

 

[FormR]

If it always prefixed with "Sales data for" and nothing else then here is another option.

Excel 2013/2016
	A	B
1	Description	Month
2	Sales Data for February 2019	February
3	Sales Data for March 2019	March
Sheet1

Cell Formulas
Range	Formula
B2	=TEXT(REPLACE(A2,1,15,1),"mmmm")

 

[howard]

Thanks for the help FormR

 

[howard]

Thanks for the help Alan

 

[howard]

Thanks for the help Fluff

Please explain how your formula works

 

[Fluff]

Which one?
I would recommend using the formula from FormR, it's a lot neater

 

[howard]

Agree, it easier to follow


Please explain this part of your formula

," ",REPT(" ",100)),100))