Dynamically extract string in excel

I have a column called 'cArticle' in excel, containing data in below format. I have a requirement to extract in another column the code that is in brackets. Ex- Z1A,F5C,etc

cArticle
Molecular Dispersion (Z1A)
Acrona Perse (F5C)
Leco Spers (HLP)
Cullar Dipters (LPP)

I have managed to get it partially working by using the below formula, but it still returns with values with the closing brackets. How can I modify it to get the desired results?

RIGHT(cArticle,4)

Thank you in advance!

https://stackoverflow.com/questions/66806110/dynamically-extract-string-in-excel March 26, 2021 at 03:09AM