Extracting portion of a text from a cell

[smalik]

Is there an easy way to extract a portion of a text from a cell without going through VBA?

Here is a sample text in a cell:
About this role:
In this role, you will:
Text (size varies)
Required Qualifications, US:
1 year of Business Operations or Leadership experience, or equivalent demonstrated through one or a combination of the following: work experience, training, military experience, education, etc. ....
Required Qualifications, International:
Text (size varies)

I have over 5,000 of these job descriptions. All I need is the text between "Required Qualifications, US" and "Required Qualifications, International". The text between the two titles could be of any size.

Any help is greatly appreciated.

Thanks in advance.

 

[Fluff]

How about

=REPLACE(LEFT(A2,SEARCH("Required Qualifications, International:",A2)-2),1,SEARCH("Required Qualifications, Us",A2)+28,"")

 

[jtakw]

Hi,

Would this work for you:

Book3.xlsx
	A	B
1	About this role: In this role, you will: Text (size varies) Required Qualifications, US: 1 year of Business Operations or Leadership experience, or equivalent demonstrated through one or a combination of the following: work experience, training, military experience, education, etc. .... Required Qualifications, International: Text (size varies)	1 year of Business Operations or Leadership experience, or equivalent demonstrated through one or a combination of the following: work experience, training, military experience, education, etc. ....
Sheet1055

Cell Formulas
Range	Formula
B1	B1	=TRIM(SUBSTITUTE(SUBSTITUTE(MID(SUBSTITUTE(A1,"Required Qualifications,",REPT(" ",LEN(A1))),LEN(A1),LEN(A1)),"US:",""),CHAR(10),""))

 

[smalik]

How about

=REPLACE(LEFT(A2,SEARCH("Required Qualifications, International:",A2)-2),1,SEARCH("Required Qualifications, Us",A2)+28,"")

Thank you... What is the significance of "+28" at the end of the formula

 

[Rick Rothstein]

Here is another formula for you to consider...

=MID(LEFT(A1,FIND("Required Qualifications, International:",A1)-2),FIND("Required Qualifications, US:",A1)+28,LEN(A1))

 

[Fluff]

What is the significance of "+28"

It's the length of "Required Qualifications, Us" (without the quotes)+1

 

[smalik]

Thank you @Fluff, @Rick Rothstein , @jtakw All three formulas worked.

 

[Fluff]

Glad we could help & thanks for the feedback.