| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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! |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 - |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Adding a number to a letter of the alphabet to get a letter | Excel Worksheet Functions | |||
| How do i set up a list that sorts as Number/letter/number in orde | Excel Discussion (Misc queries) | |||
| change headers from letter to number/number to letter | Excel Worksheet Functions | |||
| column header changed from letter to number, how return to letter | Excel Discussion (Misc queries) | |||
| Auto number w/ different letter-number combos in same column | Excel Worksheet Functions | |||
Hybrid Mode
