Letter to number

  • Thread starter Thread starter andyburghardt
  • Start date Start date
A

andyburghardt

I am trying to write a formula to take the values a cell and converts
it to a letter. For example, I have a cell that contains values from
1-5. I'd like to set it up so 1 = A, 2 = B, etc. Is there a simple
formula to do this?
 
If A1 contains the number, try this in B1:

=CHAR(A1+64)

for upper case letters, or

=CHAR(A1+96)

for lower case.

You can copy the formula down if you have other values in column A
that you want to convert.

Hope this helps.

Pete
 
If A1 contains the number, try this in B1:

=CHAR(A1+64)

for upper case letters, or

=CHAR(A1+96)

for lower case.

You can copy the formula down if you have other values in column A
that you want to convert.

Hope this helps.

Pete
Click to expand...

That worked. Thanks!
 
Back
Top