converting number to letters

  • Thread starter Thread starter Patrick
  • Start date Start date
P

Patrick

If I have a list of cells, say a1:a4 that have numbers
and I want to convert them to text in b1:b4, is there a
function out there that allows me to do it. example(w=1,
a=2, s=3, 4=h).

If a1 were 312, b1 would caluculate "swa"

thanks
 
Patrick,

Your code only has 1 digit for each letter, how will you handle 26 letters
of the alphabet?

And the 312 example has the numbers all in one cell, whereas you mention
a1:a4?

If each number is in a separate cell, you can use this function:-

=CHOOSE(B1,"w","a","s","h")

which returns the correct letter for different values in B1.

regards,

JohnI
 
I am only dealing with:

1=w
2=a
3=s
4=h
5=i
6=n
7=g
8=t
9=o
0=n

If the number is 230, I want to convert it to "asn" on my
spreadsheet. I am dealing with thousands of numbers, so
if possible I would like to convert using a formula vs.
manual.
 
patrick,

If each cell contains a 3 digit number, then the following formula should
work-

=CHOOSE(LEFT(A2,1)+(LEFT(A2,1)="0")*10,"w","a","s","h","i","n","g","t","o","
n")&CHOOSE(MID(A2,2,1)+(MID(A2,2,1)="0")*10,"w","a","s","h","i","n","g","t",
"o","n")&CHOOSE(RIGHT(A2,1)+(RIGHT(A2,1)="0")*10,"w","a","s","h","i","n","g"
,"t","o","n")

Note:- If a number begins with a zero (0), enter a single quote in the cell
(i.e. ' ) before the number.
Otherwise the formula will give incorrect results.

regards,

JohnI
 
Back
Top