Help Parsing text

[ilcaa]

I am trying to extract the text between 2 Finds, but have trouble finalizing it

TEXT: Vestian: Jim Cahn, Brad Anastasia LibreMax: Greg Lippmann, Fred Brettschneider, John Curran

Need: Jim Cahn, Brad Anastasia

so anything between the 1st : and "LibreMax"

thanks

 

[Rick Rothstein]

One way to do it...

=MID(REPLACE(A1,SEARCH("LibreMax:",A1)-1,999,""),FIND(":",A1)+2,99)

 

[Chris Mack]

This would work:

=LEFT(RIGHT(A1,LEN(A1)-SEARCH(":",A1,1)-1),SEARCH(" LibreMax:",RIGHT(A1,LEN(A1)-SEARCH(":",A1,1)-1),1)-1)

Hope this helps,

Chris.

 

[pgc01]

Hi

Do you need it done with formulas/code?
You could instead use Find/Replace directly.