View Single Post
  #4   Report Post  
bj
 
Posts: n/a
Default

fist make a table with your conversion data
then if all of the number cominations are 4 long

=vlookup(value(mid(number,1,1)),
table,2)&vlookup(value(mid(number,2,1)),table,2)&v lookup(value(mid(number,3,1)),table,2)&vlookup(val ue(mid(number,4,1)),table,2)
if you have varying length of number combinations you can make if more
complex by adding if(len() levels
"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