ExcelBanter - How to convert text "A" to a number using a formula

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - How to convert text "A" to a number using a formula (https://www.excelbanter.com/excel-discussion-misc-queries/183390-how-convert-text-number-using-formula.html)

yakky

How to convert text "A" to a number using a formula

In cell A1 I have the either Letter a, b or c.
I would like to give them a numerical value of 1, 2 and 3 in the
adjacent cell.
Can someone post or point me to the formula?
Thanks

Mike H

How to convert text "A" to a number using a formula

Put this in b1 and drag down

=CODE(UPPER(A1))-64

Mike

"yakky" wrote:

In cell A1 I have the either Letter a, b or c.
I would like to give them a numerical value of 1, 2 and 3 in the
adjacent cell.
Can someone post or point me to the formula?
Thanks

Pete_UK

How to convert text "A" to a number using a formula

Please don't multi-post - you have an answer elsewhere.

Pete

On Apr 11, 5:11*pm, yakky wrote:
In cell A1 I have the either Letter a, b or c.
I would like to give them a numerical value of 1, 2 and 3 in the
adjacent cell.
Can someone post or point me to the formula?
Thanks

Mike H

How to convert text "A" to a number using a formula

Pete,

I agree but can't see the other post in this case. Where?

Mike

"Pete_UK" wrote:

Please don't multi-post - you have an answer elsewhere.

Pete

On Apr 11, 5:11 pm, yakky wrote:
In cell A1 I have the either Letter a, b or c.
I would like to give them a numerical value of 1, 2 and 3 in the
adjacent cell.
Can someone post or point me to the formula?
Thanks

All times are GMT +1. The time now is 11:47 PM.