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.
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.