Formulas in Microsoft Excel: How to Change a Letter Into a Number : Using Microsoft Excel

Subscribe Now:

Watch More:

Changing a letter to a number in Microsoft Excel requires you to make a few key adjustments to the formula that you're already using. Learn about changing a letter into a number in the formulas at use in Microsoft Excel with help from a mechanical engineer with 32 years of experience in a large aerospace company in this free video clip.

Expert: Edward Russell
Filmmaker: Patrick Russell

Series Description: Microsoft Excel is a lot more than just a basic spreadsheet program - it can be a legitimately terrific way to keep track of nearly every type of information. Use formulas and columns in Microsoft Excel with help from a mechanical engineer with 32 years of experience in a large aerospace company in this free video series.

[waellerbe]

Dropping by to *appreciate* the lesson that you shared with us in this video. In my quest to see "letters as numbers, " I found my way to your video, and I'm mighty glad about it. Looking forward to more of your content.

[laurenbrayson]

OMG - this is soo helpful!!! Thank you so much :)

[wanasakungo]

HI, SO CAN YOU CODE IT WHEREAS YOU CAN INPUT DIFFERENT NUMBERS AND FOINSTANCE YOU HAVE AN ALGEBAIC EXPRESSION YOUR INPUT AUTOMATICALLY CONVERTS THE LETTERS INTO YOUR NUMBERS?

[neilleclair]

I am trying to build a spread sheet where if I type an X in a cell it will automatically have a value of 10. Do I need to build a ledger for formulas on my spread sheet?

[Klaskato]

Thank you.
Being a newbie to Excel, how do you concretely use that formula?

[Jregan]

One tip - don't ever change a formula within a column.  Good rule to live by.  In this example, it would be best to UPPER(A2) then CODE, which would make all of the characters uniform without having to change the actual formula in row 9.

[eurossocial]

Very helpful Tutorial. Thank you.
I have one question:
How do we change the Number "2" with other number, such as "9" for example?

[AndreasYerasimou]

hi Thank you for this tutorial, i have been trying to implement that but i didn't manage though. i would like to be able to write words or sentences in one cell and then the letters to be added according to the number that i have given to them like in your video, and give me a total value in another cell. i managed to give the letters the values that i want but after... am stuck.. i can not convert the sentence to numbers and then add them.. can you help me please!!!

[williambucher]

i created the table, how would i now add the letters togther. for example i am working with a sread sheet that uses letters to mark a value ie. D=8, i would like a function that would sum up the letters by replacing them with their assigned numeric value? ie D+D+D+D+D = 40, thank you in advance

[gloriagibson]

How would you give a letter a value for work schedules, eg. C = 7 hour shift, M = 4.5 hour shift etc. and then add them all to get the amount of hours given to a certain worker

[engayamamdouh]

amazing
it's very great
thaks alot

[atlantica]

is there a way to change the number to letter (multiple letters?) ?

[k.r.k.]

Hi!
Thanks for your video, but I have a question.
How to make it so that I only enter the letter "a" in different cells, and there were different numbers in these cells. For example: I enter the letter "a" in cell A1, and in the same cell the number "1" is output instead of the letter "a". Next, I enter the letter "a" in cell A2 and in the same cell, instead of the letter "a", the number "2" is output and so on. Thanks.

[drwatson]

Nice video. I tried to use this with foreign language letters (Hebrew) but the code was always the same 63 regardless of the letter. Any ideas?

[ritujashah]

What if the values in column A are dynamic?

[Lucastanhockhock]

hi mr, how to make it like input 12389 and auto convert to abchi

[celticsword]

How do you make those values from a word like this example in excel. math = 13 +1 + 20 + 8 = 42

[edithmorrison]

HELP, I am trying to take a tracking spreadsheet I have created and put the x value into a numerical number 1. I watched your video and was able to figure it out, but can't get it to work with my spreadsheet for tracing falls (I am a nurse) can you help? I have multiple columns of info and when a fall applies to the column I put an x in it. I need to be able to convert all my x's into a graph. and to do that I need to convert my x's into a 1

[mohammedamin]

HOW DO YOU EXCLUDE NUMBERING ATTACHED TO YOUR TITLES

[thefinest]

How can we find "vowels" in any name we enter ??