Okay, I know this is strange, but here's my thought and request:
In the English alphabet, we have 26 letters. Assuming A=1, B=2, C=3....Z=26, how would I construct a formula (or a UDF in VBA) to determine the numerical value of the contents of a cell?
For example, if the cell contained "Hello" we would have 8 for H, 5 for E, 12 each for the L's, and 15 for the O.
Adding all of those together, the "value" of the cell would be 52.
If the cell contained "Hello 7" then the "value" would be 52+7, or 59.
We could also assign other constants, like a space = 0, a comma counts as 1, a period as 2, other punctuation = 0.
So, if I had a column of cells, how would I determine the "value" of each cell in that column?
Any bright ideas would be very welcome.
Bookmarks