Dropdown list data validation - word wrap

A

Andy Bailey

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

Whistle
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Drop down list control value in vba 2
Word VBA - Automatic change content of a cell in table using dropdown list 5
Data validation list using filtered range 3
Word VBA - Auto Populate Text on Dependent Drop Down Exit 1
list or combo box 0
Data Validation - Multiple Dependent Lists 4
data - validation - list question 2
drop box/data validation help 0

Top