PDA

View Full Version : Filter validation list



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

Krishna Kumar
01-18-2009, 12:31 AM
Hi Suji,

It's not hard coding, but would display the first four letters. Try custom formatting the cells,

"AA-A"#;"AA-A"@

Bob Phillips
01-18-2009, 07:26 AM
But you would also need code to pre-pend the cell value with AA-A, to get the true required value.