I have BSU's that share a prefix in this format- 7HP, 7AP, and have some letters after that for different departments.
Then I have indepenedent departments with no client prefix in this format- 2HO, 1HO,ZHO, etc.
I want to make an IF statement with multiple wildcards, something like...