Translating Excel Text Via Cipher

[Besjbo]

I'm trying to simplify the encoding of text in my spreadsheet with a simple cipher (BEE would become CFF). Is there some convenient way to set up a key ("A->B, B->C, etc.") and then set up an area of the spreadsheet to encode text from reference cells? Besides doing everything by hand without using the spreadsheet, the most time-efficient thing I've thought about is using =IF(mid(A1,1)=A,B,IF(mid(A1,1,1)=B,C,IF... to generate an encoded version of the nth letter in a cell, producing the string of encoded text one letter per cell over a row, and then combining the characters in that row into one cell, and then replacing 'A1' with any other cell to repeat the process. But, this is very inefficient, as I'm spending a lot of cells and time on each cell to be encoded.

[popipipo]

=CHAR(CODE(LEFT(A1,1))+1)&CHAR(CODE(MID(A1,2,1))+1)&CHAR(CODE(RIGHT(A1,1))+1)
Try is formula

[Besjbo]

Thanks! Is there any way to adapt that to an irregular cipher e.g. A -> C, B-> E, C->B, D-->F, or a code using more than one character e.g. EB -> A, AC -> B? Incrementing Unicode is a really clever way to perform an "add one" command to letters, but is specific to Caeser ciphers, and I was hoping to find a solution that allows you to "translate" however you want given a key, without necessarily writing the logic behind the code into Excel.

[popipipo]

Excel has difficulties to count with irregularity
Make al list of all the combination and you can use VLOOKUP to translate.