Text to Numbers

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 [...]

Read Full Post »

Converting numbers to words

How do we convert numbers to words. Especially useful if you are writing cheques (checks) through printing through a soft file. The logic given below is one for India – it uses crores and lacs. The logic works for all numbers between 1 and 99,99,99,999 (100 crore -1) Say the numbers that need to be [...]

Read Full Post »

Remove spaces from a cell

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 [...]

Read Full Post »

Separating names into last and first names

I had encountered this problem while carrying out mail merge. Usually names are stored in a single field. In order to carry out mail merge for a letter/mailer, last names needs to be stored in a separate field to faciliate merge as Dear Mr/Ms last_name The original list is stored in column A whereas the [...]

Read Full Post »