Trying to Extrarct Text from the Middle of a Text String

Hello everyone. So here's the issue I'm having. I have a string of text that reads like below.

Flange-Material Grade (UNS, EN, AISI): Inconel 601, UNS-N06601

Parts of this string will vary, parts will stay the same. Example below.

Flange-Material Grade (UNS, EN, AISI): ***This always stays the same***
Inconel 601 ***This will vary***
, UNS-N06601 ***This will vary***

My thought was something along the lines of =LEFT(A1, then 39 characters in,- the comma and everything after it)...but you know, more formulaic. Any thoughts? Would greatly appreciate the help. Tks.

What is the desired result based on your one example?

This will return Inconel 601 with your example string in A1.

=MID(A1,40,FIND(",",MID(A1,40,LEN(A1)))-1)

Basically the layout is the same on all the them. They all start the same way, but the back end changes based on the change in material. I'm trying to inly extract the material information. The number of characters varies however. Sometimes it's two or three letters; F5, F11, CS....In the above example it's Inconel 601. That's what I'm after. Inconel 601. Thanks for your help.

Perfect! See post #3.

Looks like that's doing the trick. Works great. Appreciate the help. You just saved me a week of messing around with this stuff. Thanks again.

You're welcome. Happy to help!