Kestrel1492 Wrote:
I Hope I'm just overlooking a stock standard way to do this, but:

I'd like to find a fairly simple way to convert text in a cell to a
numerical value, that I can then use as a checksum.
I don't mean cells containing the word"one" would equal 1, but rather
something like ("o"=15)+("n"=14)+("e"=5)=34
I want to use it to help uniquely identify rows, so it has to be
simple, or it will take too long to execute and be counter productive.

Thanks,
Kestrel

An easy way (as I see it) is to enter your addends in different cells.
For example,

A1 contains "o"=15
A2 contains "n"=14
A3 contains "e"=5

and then, you can enter this formula in

Cell B1: *=value(right(A1,len(A1)-find("=",A1)))*

Next step is to copy the formula in B1 down to B3. In cell B4, you can
enter this formula

=SUM(B1:B3)

to get your desired result.

I hope I interpreted your problem correctly.

Regards.


--
BenjieLop


------------------------------------------------------------------------
BenjieLop's Profile: http://www.excelforum.com/member.php...o&userid=11019
View this thread: http://www.excelforum.com/showthread...hreadid=385637