Try this:
=IF(INT(A1/1000)=0,"J",CHAR(INT(A1/1000)+64))&IF(INT(MOD(A1,1000)/100)=0,"J",CHAR(INT(MOD(A1,1000)/100)+64))&IF(INT(MOD(A1,100)/10)=0,"J",CHAR(INT(MOD(A1,100)/10)+64))&IF(MOD(A1,10)=0,"J",CHAR(MOD(A1,10)+64))
Only works for 4 digit numbers
HTH
"jplazola" wrote:
I am trying to find a formula that will convert existing number combinations
into corresponding letter combinations in Excel. The relationship of numbers
to letters is as follows:
1 = A 6 = F
2 = B 7 = G
3 = C 8 = H
4 = D 9 = I
5 = E 0 = J
For example, I'd like to convert a cell that contains '1250' to 'ABEJ'
I've had no success with the HELP feature in Excel.
Thank you for any help you may provide
Jason