Hello,
I hope someone can help me with this.. I'm looking for a formula that will find the "text" within a string of texts and numbers like this example below. So if this was my string going across from A1-H1, I want to return the value of "SR". I want to overlook the numbers in the cell. Is this possible?

In cell A1 - SR , In cell B1 - 8 , In cell C1 - SR , In cell D1 - 8 , In cell E1 - SR , In cell F1 - 8 , In cell G1 - SR , In cell H1 - 8 = SR

Thank you so much.

Trish