Hi,
I am trying to create a list of responses that would be displayed to a user
via a drop down list and when a response is selected only a short version (eg
3 letter code) would be displayed in that cell.

My initial thought we
Create a list called CODE eg
CAR CArdiovascular
DEV Developmental
DSY Downs syndrome
EYE Eye Nystagmus
GAS Gastrointestinal

I was hoping that I would be able to use Data Validation option with some
formula in the list option, eg =left(CODE,3).
But this does not work :(
Any ideas?