substitute formula needed

[iamkennyjacobs]

Need to remove all but one variable string from a cell.


Example:
K2 Cell contains: "specific text string hereAAAA-BBBB-CCCC assignment..."
H2 formula result: CCCC

Details:
AAAA, BBBB and CCCC represent text strings that are variable in characters and number of characters.
Every line begins with a specific text string that is constant
Everything after CCCC begins with " assignment" followed by variable text)

 

[Fluff]

Hi & welcome to MrExcel.
How about
=TRIM(LEFT(RIGHT(SUBSTITUTE(SUBSTITUTE(K2,"assign",REPT(" ",500)),"-",REPT(" ",500)),1000),500))

 

[iamkennyjacobs]

Perfect! Thank you for your assistance!

 

[Fluff]

You're welcome

 

[Rick Rothstein]

Perfect! Thank you for your assistance!

This formula should also work...

=TRIM(RIGHT(SUBSTITUTE(LEFT(K2,SEARCH("assign",K2&"assign")-1),"-",REPT(" ",999)),999))

 

[iamkennyjacobs]

Appreciated Rick! Thanks!