Dropdown menu

[bonhill66]

I want to creat a dropdown menu that will display in the cell on part of what
is shown on the dropdown menu. For example, if the dropdown menu item is
"A101 - plan & prepare for", and want the cell to display "A101". Is that
even possible? If so, how?
Thanks.

 

[Debra Dalgleish]

You can do this with programming. There's a sample file here:

http://www.contextures.com/excelfiles.html

Under data validation, look for 'DV0005 - Data Validation "Columns"'

 

[bonhill66]

Thanks. But I guess I'm not smart enough to figure that out. Do you have an
easier explanation?