Letter to number
 

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?

Letter to number
 

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

On Sep 18, 4:34 pm, "
wrote:
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?

Letter to number
 

On Sep 18, 11:38 am, Pete_UK wrote:
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

On Sep 18, 4:34 pm, "

wrote:
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?

That worked. Thanks!

Letter to number
 

You're welcome, Andy.

Pete

On Sep 18, 5:47 pm, "
wrote:
On Sep 18, 11:38 am, Pete_UK wrote:





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

On Sep 18, 4:34 pm, "

wrote:
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?

That worked. Thanks!- Hide quoted text -

- Show quoted text -