The trick of ––

You read it right. Its going to be a quick post but at the end of it, you would be glad that you read it. Trick1: Text to Number  Consider this =ISNUMBER(LEFT(12345,1)) – this returns FALSE as this simplifies to =ISNUMBER(“1″) However, =ISNUMBER(––LEFT(12345,1)) returns TRUE. The two minus signs in conjunction “––” converts text “1″ [...]

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 »

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 »