Just like that, each alphabet corresponds to a number, summing up alphabets I cant really see how this post could be useful to you. One of my friends who believed in numerology brought this problem to me of converting names to numbers. Here is the solution that we worked out. You may treat this as [...]
Posts Tagged ‘Substitute’
Text to Numbers
Posted in Just Like That, tagged array formula, code, indirect, Len, lookup, lower, mid, row, Substitute, sum on June 8, 2009 | 1 Comment »
Remove spaces from a cell
Posted in Uncategorized, tagged Len, Substitute, Trim on July 16, 2008 | Leave a Comment »
Often when a list is imported from another application, you would find that there are unwanted spaces within cells. If there are spaces in a numeric cell, excel reads it as text field. This means no calculation can be carried out on them. For instance if a cell contains 1234 1 (space between 4 and [...]
Author
Search blog
-
Recent posts
-
Blog Stats
- 15,059 hits
Share with others!
What have I used most
Get down to work!
May 2012 M T W T F S S « Jul 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31
