Dependant drop down list with more than two words in the options

J

Jock

I have looked at Debra Dalgleish's site but can't find the answer for this one.
I have a named list with only four option but each of the four entries is
between 8 and 10 words long. I can't reduce them to one or two word options.
The second, dependant list has similarly long options.
How do I get the second list to refeerence the first but using these multi
worded options?
Can I modify the =INDIRECT(SUBSTITUTE(A1," ","")) function?
 

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

How to make repeating drop-down lists? 2
Adding a big matrix in Word 2013 5
dependent, multiple variable, drop down list 2
Drop Down List Dependant Formula 2
How to modify and updte specific styles for specific paragraphs across the document 0
Word VBA - Auto Populate Text on Dependent Drop Down Exit 1
dependent drop down list 1
multiple dependent drop down lists 6

Top