Alpha coding

[alliswell]

a b c d e f g h i j k l m
n o p q r s t u v w x y z

Hi everybody !
In a1 is some coding.
In b1 whenever i write "a" i shud get "n" & if i write "n" i shud get "a". For example i want to write "hello" it shud get converted to "uryyb" because above in alphabets below h is u, below e is r, below l is y and anove o is b that becomes hello when converted in coding language.

Try with formula plz

Thanks & regards to all my mrexcel team

 

[Peter_SSs]

Hi peter
Can you provide me the same formula for royal kings too plz.
royalkings
1234567890
When i type r i must get 1 and whenever i type 1 i must get r. Both ways working will be easier for me to print on labels quickly.

You don't need a different formula. Use the same formula. Just put ..
royalkings
1234567890
.. into cell A1 with an Alt-Enter between as before.

alliswell.xlsm
	A	B
1	royalkings 1234567890
2
3
4	singor	078921
5	2468	oakn
Coding (2)

Cell Formulas
Range	Formula
B4:B5	B4	=LET(s,SUBSTITUTE(A$1,CHAR(10),""),m,LEN(s)/2,c,MID(A4,SEQUENCE(LEN(A4)),1),p,FIND(c,s),CONCAT(IFERROR(MID(s,MOD(p-1,m)+1+m*(p<=m),1),c)))

 

[alliswell]

Love you sir. Million thanks