Assigning numerical values to certain charachers

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Joel N - 25 Oct 2007 21:55 GMT

I'm trying to find out how to assign numerical values to specific letters.
It's just a simple matter of A=1, B=2, C=3 etc. What I need to do is to
write a paragraph for my college Lit. class that "equals" a certain number.
i.e. abc=6. Can anyone help?

Reply to this Message

Rick Rothstein (MVP - VB) - 25 Oct 2007 22:22 GMT

> I'm trying to find out how to assign numerical values to specific letters.
> It's just a simple matter of A=1, B=2, C=3 etc. What I need to do is to
> write a paragraph for my college Lit. class that "equals" a certain
> number.
> i.e. abc=6. Can anyone help?

Is you ultimate goal to be able to add up the letters in a particular cell
(where 'A' or 'a' is 1, 'B' or 'b' is 2, etc.)? Assuming spaces don't add
anything to the total, this formula should do that...

=SUMPRODUCT((CODE(MID(A1,ROW(INDIRECT("A1:A"&LEN(A1))),1))-96)*ISNUMBER(FIND(MID(A1,ROW(INDIRECT("A1:A"&LEN(A1))),1),"abcdefghijklmnopqrstuvwxyz")))

where, for this example formula, I assumed the text was in A1. This formula
can be copied down.

Rick

Reply to this Message

Joel N - 25 Oct 2007 22:55 GMT

Actually, what I'm trying to do is write a paragraph in Word and total the
letters. It was recommended that I try Excel but it doesn't make sense to
try to type a paragraph in one cell. Any suggestions?

> > I'm trying to find out how to assign numerical values to specific letters.
> > It's just a simple matter of A=1, B=2, C=3 etc. What I need to do is to
[quoted text clipped - 12 lines]
>
> Rick

Reply to this Message

*alan* - 26 Oct 2007 01:11 GMT

Actually, Joel, you're being very unclear. What is it you *really* want to
do?
1. assign values to letters and get a total of the values? If so, then
you've been given the solution.
2. count the occurrences of each letter?
3. count the total number of letters?
4. none of the above?

> Actually, what I'm trying to do is write a paragraph in Word and total the
> letters. It was recommended that I try Excel but it doesn't make sense to
[quoted text clipped - 20 lines]
>>
>> Rick

Reply to this Message

Rick Rothstein (MVP - VB) - 26 Oct 2007 05:21 GMT

I'm not sure what you are asking of me at this point. Word is not Excel, so
the formula I gave you can't be used in Word. Word does have a VBA macro
language available like Excel does, but the Object model for each are
completely different; so, if you want a Word solution, then you are in the
wrong newsgroup. I'm not sure who recommended that you try Excel, but it
certainly can do what you asked (using the formula I posted earlier); and,
yes, you could enter (or copy/paste) a paragraph into a cell in Excel. I'm
curious, though, why would you want to add up the letter values for a
**large** paragraph of text?

Rick

> Actually, what I'm trying to do is write a paragraph in Word and total the
> letters. It was recommended that I try Excel but it doesn't make sense to
[quoted text clipped - 20 lines]
>>
>> Rick

Reply to this Message