"bank of america" required answer in short form→ as a "BOA" in formula only sir

[GVN KUMAR]

sir
any formula for stat bank of india (required answer → SBI ) its short form

any formula or idea sir

mid formula not working sir
Ctrl+E did not require sir

required formula sir for the above short form purpose

 

[vletm]

GVN KUMAR
= if(C5="stat bank of india","SBI",C5)

 

[GVN KUMAR]

thank you sir and super idea sir