No, you get what you select, you would need an extra cell for that


Regards,

Peo Sjoblom



"Chris" wrote:

I set up my validation drop down list. One of the items is TELEPHONE 6200. Is
there a way that when someone chooses that item, only the 6200 shows in that
cell? Like using a RIGHT formula? Thanks