suji
01-17-2009, 11:35 PM
Hi,
I have an excel dropdown validation list with over hundred items wherein the first four letters of all items are same and only the last two letters are different.
Eg : AA-A12, AA-A13, AA-A1B, AA-A1C etc.
Is it possible to have first four letters hardcoded so that I just have to type the last two letters to select from the dropdown list ?
Thanks
Suji
I have an excel dropdown validation list with over hundred items wherein the first four letters of all items are same and only the last two letters are different.
Eg : AA-A12, AA-A13, AA-A1B, AA-A1C etc.
Is it possible to have first four letters hardcoded so that I just have to type the last two letters to select from the dropdown list ?
Thanks
Suji