Text within Cell

[mkanchwala]

Hi All,

I have a set of lines similar to the one below, and I am only trying to get the text between "of" and "Jan" or any other month. The text length is different. What is an appropriate formula to get this? All help is greatly appreciated.[TABLE="width: 154"]
<tbody>[TR]
[TD="width: 154"]
Sum of Salaries Jan[/TD]
[/TR]
</tbody>[/TABLE]

 

[Giordano Bruno]

Is there always only one word between "of" and "Jan"? Is the month always the last word?

 

[mkanchwala]

Hi Giordano,

There may be multiple words but it will always fall within "of" and the last 3 characters "Month", yes the month will always be the last word. Thank you

 

[FormR]

There may be multiple words but it will always fall within "of" and the last 3 characters "Month", yes the month will always be the last word.

Hi, welcome to the posting side of the forum!

Here is one option you can try:

Excel 2013/2016
	A	B
1	Sum of Salaries Jan	Salaries
2	Office count of supplies Mar	supplies
3	Count Of Christmas Trees Dec	Christmas Trees
4	average of the month end balance of the credit card bill Jun	the month end balance of the credit card bill
Sheet1

Cell Formulas
Range	Formula
B1	=MID(LEFT(A1,LEN(A1)-3),SEARCH(" of ",A1)+4,255)

 

[Peter_SSs]

Based on the sample data in FormR's post, I'd suggest a slight change to eliminate the blank space being returned at the end of each of those results

=MID(LEFT(A1,LEN(A1)-4),SEARCH(" of ",A1)+4,255)

Another similar option:
=REPLACE(LEFT(A1,LEN(A1)-4),1,SEARCH(" of ",A1)+3,"")