How to Make a Letter Equal a Number in Excel | A=1, B=2 etc

In this video I demonstrate how to convert a letter into a number, so for example A will become 1 and B will become 2. This method works for upper and lower case letters.

The functions used in this video are CODE and UPPER.
------------------------

[countduckula]

Chester, that was an interesting video that combined code & upper functions. Thanks.

[IvanCortinas_ES]

A great and unknown formula Chester. Thank you for this video.

[daviddayanidhi]

Ok, can we assign a particular value to a letter... Let's say if I want to assign 265.32 to A, is that possible?

[KTF]

Thank you this saves me a boat load of time.

[pleasantpaula]

Great video, how would you convert S, E, G continously down a column to 1, 2 or 3? Trying to code emergency data self presents, GP reffered, Emergency referred

[AAROIDHAYANJMBOSCO]

Hi Mr, Tugwell,
Thanks for the video. I have text responses from a MS Form. I wish to assign numerical values to these texts. Is there an option to do this?

[rohitsarathe]

thanks, your content has helped a lot

[tee]

How do I subtract and add using the loop? Example- 26+1 = A

[faysalahmed]

If a=1, b=2, c=3, d=4, e=5, f=6, g=7, h=8, I=9, j=0, so if I write to d3 1234, e3 should abcd, so how to set function, can you tell me

[JetraxVRU]

And how do i link a number (exemple :1) to a text_V1 and a "2" to a text_V2 etc... ?

[rohitsarathe]

Is there a way we can convert numerics to text, like 1 to A, 2 to B

[punithnagali]

How to converte to a number
Example:
ABB=122. CBA =321.FGJ=670
DDD=444. BAI =219
how to create in excel sheet.