Convert Names to Numbers (text to numbers)

[pwebley]

Is there a way to convert a name to a numerical value using formulas. Example:
John = 123

The name would actually convert to a number because of the value of each character. Any help would be appreciated.

 

[CWatts]

press CTRL+F3 and that will open the name manager. Then you can assign numbers to names.

if you already have a list, you can quickly add names by highlighting the two columns and using CTRL+SHIFT+F3

 

[hiker95]

pwebley,

What values are you assigning to each character to get your total of 123?

Excel Workbook
	A	B	C	D
1	John		J	74
2			o	111
3			h	104
4			n	110
5				399
6
Sheet1

 

[pwebley]

My example of John=123 was only an example. That is what I would like it to do.

 

[CWatts]

pwebley,

What values are you assigning to each character to get your total of 123?

Oh disregard my post then I misunderstood. If you're going to have each character assigned to a number, we'd also need to know what methodology you're wanting to use to get your end-result number: addition, multiplication etc...

 

[Rick Rothstein]

Way more information about what you are intending to do is needed before you can get any sensible help.

 

[hiker95]

pwebley,

You will probably have to take into consideration that upper and lower case letters have different ASCII values.

Excel Workbook
	A	B	C	D	E	F	G
1	John		J	74		j	106
2			o	111		o	111
3			h	104		h	104
4			n	110		n	110
5				399			431
6
Sheet1

 

[hiker95]

pwebley,

If you were to put together a list of all letters and the values you want to assign to them, a User Defined Function could be written to accomplish the task.

 

[pwebley]

To help you understand, because I was not clear enough. I have a list of names that I would like to sort alphabetically using a formula. That way the list of names automatically sorts when I add new ones or change existing ones. The sort would occur in a different column with the array of names being somewhere else.

 

[Rick Rothstein]

My example of John=123 was only an example. That is what I would like it to do.

Okay, then the answer to your original question is "yes". Unfortunately, given all the information you have posted so far, it is kind of impossible to give you a more detailed answer.