how do I dropdown list
 

I need a drop down that will show a code and a description of that code, but
after I select it I only want the code visible.

how do I dropdown list
 

All in the same cell?

Can probably do this with Data Validation dropdown and some event code.

Post some examples of code and description.


Gord Dibben MS Excel MVP

On Tue, 12 Jan 2010 12:16:01 -0800, JM wrote:

I need a drop down that will show a code and a description of that code, but
after I select it I only want the code visible.