extracting part of a code from a cell & using it in a formula
Posted by Jeannette on January 27, 2002 2:59 AM
I have a cell with a code ex: (LMDE or MDF) and each letter represents a code in order to calculate based on the letter. The problem is the letter is never in the same location when I look for it in the cell, how can I search the cell and if it finds the letter I am looking for then perform my calculation? I have tried using the left() function and I can't seem to get it to continue searching to the next postion until found. I hope this isn't confusing and someone can help, thanks!