CodePudding user response:

[B2]=LEFT (A2, 3) & amp; CHAR (CODE (MID (A2, 4, 1)) + 16) & amp; CHAR (CODE (MID (A2, 5, 1)) + 16) & amp; CHAR (CODE (MID (A2, 6, 1)) + 16) & amp; CHAR (CODE (MID (A2, 7, 1)) + 16) & amp; RIGHT (A2, 4)

CodePudding user response:

Decrypt the reduction formula of how to write? Thank you very much!

CodePudding user response:

16 + 16 into - bai

CodePudding user response:

13323458888 example which seems incorrect. 133 bcde8888 isn't it?

CodePudding user response:

The encryption method and the original poster is too simple, by comparing suddenly found that the law isn't it, it is best not to correspond to 1 A, 2 B, corresponding better think of some other way,