Convert number to letters and letters to numbers by code function and char function

This video explains, how to convert capital and small alphabets into numbers and numbers to alphabets.
We can use Code Function and Char Function so that excel convert text to number and convert numbers to letters.

[jaimeespinoza]

Thanks, this way helps to identify the numbers for the letters.

[treeoflife]

How did you come up with the code? And char?

[iluvemyroom]

it would be nice if you had converted any numbers to characters. e.g. how to write 18000 in aphabetical order.

[loyalkishore]

Need To Assign numbers to an Alphabet if i type 1 it should be A 2 is b then if type 123 its should be ABC if i type cba 321 X= o Example 1024 it has to be AXBD kindly advise how assign this