Excel is Cool! Linnce • Now • 100%

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

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"?

Excel is Cool! EvilEwok • Now • 75%

EVE Online launches free Microsoft Excel Add-on - sh.itjust.works

Wild

Excel is Cool! em2 • Now • 100%

Excel shortcuts. [@excel@lemmy.ml](https://lemmy.ml/c/excel)

Excel shortcuts. [@excel@lemmy.ml](https://lemmy.ml/c/excel)