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