Convert text strings to a code or number
On Wed, 22 Mar 2006 13:35:28 -0800, Kevin Vaughn
wrote:
I previously copied the following formula from the site (don't remember who
originally contributed it,) and I modified it slightly to get rid of Upper
and subtracting 33. Note: this is far from perfect, but I doubt there is a
perfect solution to your request.
=SUMPRODUCT(CODE(MID(A1,ROW(INDIRECT("1:"&LEN(A1) )),1)))
TomBill 691
BillTom 691
FrankJohn 897
JohnFrank 897
DAD 201
BEB 201
Is the OP interested in telling whether or not TomBill and BillTom are composed
of identical word strings, or is he interested in knowing if the ASCII codes of
the letters add up to the same value?
There are many combinations that will add up to 691:
TomBill
BillTom
KimJune
JuneKim
WilmaJo
etc.
--ron
|