Find most words in string with numbers included

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

Please see attached.

Unless I'm missing something, why not just
=A3

I'm trying to return the location in this case (SR) from the string.. This is a list of an employee's hours for the week. Sometimes he goes to location "SR" and works the hours next to the location but yes to answer your question, i just need the most occurence location from that string. The problem i was having was that since there is numbers in between, my formula wouldnt return the SR.. My original formula looked like this:

=INDEX(A3:N3,MODE(MATCH(A3:N3,A3:N3,0)))

but if the employee didnt work on a Sunday or something, it would return 0.00

Hi Fluff,

I need the number to go across not down, so I wouldn't be able to use that.

KOKOSEK,

Will you be able to help me with this one?

Thank you Caracalla.. That worked except for when there is no data i got an error message, how can I add to the formula to return blank if there is no data?

You confirmed the formula with

control + shift + enter ?

Yes i did and it worked with the ones with data but the cells without i got an #N/A error

O3=IFERROR(INDEX(A3:N3,MODE(IF(ISTEXT(A3:N3),MATCH(A3:N3,A3:N3,0)))),"")

Control+shift+enter

Just wrap it in an Iferror
=iferror(INDEX(A3:N3,MODE(IF(ISTEXT(A3:N3),MATCH(A3:N3,A3:N3,0)))),"")

Perfect thank you and be safe...