Need some experts to assist. Not getting this one figured out. Need an excel formula to capture the Team name. This first case it is SD, second is Dal.
Nate Kaeding, SD K
David Buehler, Dal K P
These are listed in a column A. I tried a number of different options but getting hungup on some teams have two letters and some have three.
Can someone assist?