# Key Board in Excel

#### callsidd

##### Board Regular
Hi,

Hope all is well there. I have seen various numerology sites, where when we input our name it describes the numeric value...

Is it possible to have the same in excel?

Regards,

### Excel Facts

What is the fastest way to copy a formula?
If A2:A50000 contain data. Enter a formula in B2. Select B2. Double-click the Fill Handle and Excel will shoot the formula down to B50000.
What do you mean by the "numeric value"?

Hi,

Do you mean something like this?...

Excel Workbook
ABCDEFGHIJKLM
1NameResult
2Akashwani822LettersAkshwani
3Code6510711510411997110105
4
5callsidd724Letterscalsidd
6Code9997108115105100100
7
8MrExcel619LettersMrxcel
9Code7711412099101108
10
Sheet5

The formula in E2, E5, E8 needs to be copied across, this will extract each individual letter from the name.
The formula in E3, E6, E9 needs to be copied across and will assign the value of that letter based on the ASCII Character Table(Map)
The formula in B2, B5, B8 then sums all those values.

I hope this helps.

Ak

Oh Yes Mr. Akashwani .....You got it & done it .... Great job ... Can we change the code?

Hi,

Do you mean something like this?...

Excel Workbook
ABCDEFGHIJKLM
1NameResult***********
2Akashwani822*LettersAkshwani*
3***Code6510711510411997110105*
4*************
5callsidd724*Letterscalsidd**
6***Code9997108115105100100**
7*************
8MrExcel619*LettersMrxcel***
9***Code7711412099101108***
10*************
Sheet5

The formula in E2, E5, E8 needs to be copied across, this will extract each individual letter from the name.
The formula in E3, E6, E9 needs to be copied across and will assign the value of that letter based on the ASCII Character Table(Map)
The formula in B2, B5, B8 then sums all those values.

I hope this helps.

Ak

Hi,

I'm pleased it works for you and thanks for the feedback.

What do you mean "can we change the code"?

Ak

Hi Thanks for your response .... If I wish to assign codes to the alphabets then how can i change it? For example I wish to give 1 to A, 2 to B, 3 to C & so on till Z ..... Is there any possibility to assign?

Thanks ....

Hi,

I'm pleased it works for you and thanks for the feedback.

What do you mean "can we change the code"?

Ak

Hi,

Do you mean something like this?...

Excel Workbook
ABCDEFGHIJKLMNOPQ
1NameResultNumberLetter
2Akashwani87Letters1111198231149A1
3B2
4callsidd64Letters31121219944C3
5D4
6MrExcel80Letters13185243512E5
7F6
8G7
9H8
10I9
11J10
12K11
13L12
14M13
15N14
16O15
17P16
18Q17
19R18
20S19
21T20
22U21
23V22
24W23
25X24
26Y25
27Z26
28
Sheet10

You will need to copy the formulas in column E across.

I hope that works for you.

Ak

=SUMPRODUCT(CODE(UPPER(MID(A2,ROW(INDIRECT("1:"&LEN(A2))),1)))-64)

Excel Workbook
AB
1Name
2Akashwani87
3callsidd64
4MrExcel80
Sheet1

Hi Scott,

That is amazing, wow, thanks for your contribution.
Could you please break the formula down and give me an Excel lesson please?

Thanks

Ak

I am using ROW(INDIRECT("1:" & LEN(A2)) to generate the numbers for row between 1 and the length of the string.
I am putting this in for the start position of MID to generate an array of all the characters in the string (since I am using this in a function that supports arrays).
I am forcing them all to UPPERcase to limit the ASCII character set (assuming all letters to 65-90) and then subtracting 64 to get the values 1-26
SUMPRODUCT is designed to work with arrays and since there is no second array will add up all the values in the array.

If you click on the cell with the formula, and then click on the Formulas tab, then Evaluate formula and step through it, you will see how it evaluates.

Replies
3
Views
218
Replies
2
Views
154
Replies
1
Views
191
Replies
2
Views
175
Replies
2
Views
71

1,202,962
Messages
6,052,815
Members
444,602
Latest member
Cookaa

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back