Interesting query and smart solution.
Query:
Dear Friend <br> i want to make an excel sheet. <br> For example i want to give number to a = 1, b =2, c= 3, d=4, e=5 and so on. <br> now whenever i enter a name in cell e.g., i write "ca" it should be displayed as 4 (that is 3 for c and 1 for a) "da: should be displayed as 5 <br> cat shoould be displayed as 24 (3 for c, 1 for a and 20 for t) <br> is there any way to do this in excel?
Answer see attached file. very very simple solution by using just two formula : LEN & IF
CAclubindia
