I want to create a list of codes of initials as a drop down list - which I
know how to do,
but I want them to see the full name but only the initials to be inputted
into the table

eg they see
JB Joe Bloggs
SD Suzie Donovan
JD Jack Daniels

but only the SD part is inserted into the spreadsheet,

is this possible??

Many thanks in advance