Change characters in text to other text

[Jonathan11235]

Hey,

Say I have a cell with the number 312 in it and I want to have in the cell next to it a formula which somehow converts 0 to A, 1 to B, 2 to C, etc. So the next cell would say DBC. Is this possible?

Thanks in advance

[tony h]

The following will work but (to my mind is rather cumbersome) but may suit if it just the range 1-9 that is in the input side.
You will need to extend it for your purposes.

=SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(H2,"1","A"),"2","B"),"3","C")