DATA VALIDATION with LEFT function
I would like to use a data validation List and enter only the first
character from that list.
For example my list is below and named Types
C - Construction
D Demolition
E Equipment Installation
R Repair
The cell to be filled only needs the first letter not the whole content of
the list.
I try to use LEFT function in the Validation Source and I can not make it
work with
The name source =Left(=Types,1)
Can someone help or suggest a different way use the data validation, like
use two columns display the description in one and enter data from the other.
Thanks.
|