Here at the University, I am trying to convert some text in system A
to match another version of the text in another system B so I can just
do a simple vlookup. I just need to convert System A.

System A
NA-SMG-SA-CARDS
NA-SMG-SA-EBZ
NA-SMG-SA-RAL
NA-SMG-SA-RAT
NA-SMG-SA-RNBAW

Sytem B
SCNCRDU
SCNEBZU
SCNRALU
SCNRATU
SCNRBU

I have 4 formulas for CARDS in 4 cells before i decided to post. All
I have is CRD. I need converted to SCNCRDU. So, I have to add the
"U" and the "SCN". I know there has to be a better way than what I am
doing.

=FIND("-",E2,4)
=RIGHT(E2,D2-3)
=SUBSTITUTE(C2,"A","")
=LEFT(B2, LEN(B2)-1)

Any help will be appreciated.

Thanks,
Ty