Key Board in Excel

[callsidd]

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,

 

[NewOrderFac33]

What do you mean by the "numeric value"?

 

[Akashwani]

Hi,

Do you mean something like this?...

Excel Workbook
	A	B	C	D	E	F	G	H	I	J	K	L	M
1	Name	Result
2	Akashwani	822		Letters	A	k	s	h	w	a	n	i
3				Code	65	107	115	104	119	97	110	105
4
5	callsidd	724		Letters	c	a	l	s	i	d	d
6				Code	99	97	108	115	105	100	100
7
8	MrExcel	619		Letters	M	r	x	c	e	l
9				Code	77	114	120	99	101	108
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

 

[callsidd]

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
	A	B	C	D	E	F	G	H	I	J	K	L	M
1	Name	Result	*	*	*	*	*	*	*	*	*	*	*
2	Akashwani	822	*	Letters	A	k	s	h	w	a	n	i	*
3	*	*	*	Code	65	107	115	104	119	97	110	105	*
4	*	*	*	*	*	*	*	*	*	*	*	*	*
5	callsidd	724	*	Letters	c	a	l	s	i	d	d	*	*
6	*	*	*	Code	99	97	108	115	105	100	100	*	*
7	*	*	*	*	*	*	*	*	*	*	*	*	*
8	MrExcel	619	*	Letters	M	r	x	c	e	l	*	*	*
9	*	*	*	Code	77	114	120	99	101	108	*	*	*
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

 

[Akashwani]

Hi,

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

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

Ak

 

[callsidd]

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

 

[Akashwani]

Hi,

Do you mean something like this?...

Excel Workbook
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q
1	Name	Result													Number	Letter
2	Akashwani	87		Letters	1	11	1	19	8	23	1	14	9		A	1
3															B	2
4	callsidd	64		Letters	3	1	12	12	19	9	4	4			C	3
5															D	4
6	MrExcel	80		Letters	13	18	5	24	3	5	12				E	5
7															F	6
8															G	7
9															H	8
10															I	9
11															J	10
12															K	11
13															L	12
14															M	13
15															N	14
16															O	15
17															P	16
18															Q	17
19															R	18
20															S	19
21															T	20
22															U	21
23															V	22
24															W	23
25															X	24
26															Y	25
27															Z	26
28
Sheet10

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

I hope that works for you.

Ak

 

[Scott Huish]

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

Excel Workbook
	A	B
1	Name
2	Akashwani	87
3	callsidd	64
4	MrExcel	80
Sheet1

 

[Akashwani]

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

 

[Scott Huish]

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.