From: Andy Bailey on
I have a column of cells that contain part names and descriptions. The
descriptions are multi-lined within the cell via line feeds of Alt+Enter.

I would like to use this range as the source for a data list. However the
drop down list generated shows each cell as a continous line.

Eg, if I have a cell with

Type: Shiny
With chain

Then the drop down list row for this is:-
WhistleType: ShinyWith chain

Is there any way to just use the first line?

I know I could separate the name from the description but this will impact
on the functionality of the rest of my work!

Any help appreciated. Thanks, Andy