How do I extract text between two of the same characters on a string, given that said character has appeared before?

excel·Excel is Cool!byLinnce

I'm trying to extract the diameter here, so for example from the strings

1234-AB-001-4"-X01 and 1234-AB-002-1.1/2"-X01

how do I exctract the 4" and 1.1/2"?

See if this does it for you: =TRIM(MID(SUBSTITUTE(A1,"-",REPT(" ",LEN(A1))),3*LEN(A1)+1,LEN(A1)))

This is assuming A1 is where the string is. The 3 in 3*LEN(A1) is what determines which string will be extracted, like so:

0  ->  1234
1  ->  AB
2  ->  001
3  ->  4"
4  ->  X01

Linnce reply

It worked! Thanks so much, I was going crazy over this.