Mixed reference/string options in Data Validation dropdown list?

[Kelvin Stott]

Hello, I am trying to create a dropdown list of options with data validation, but combining strings and cell references as follows:

Data Validation Source: "ALL",B2:B8,"Other"

Unfortunately this just gives me a dropdown list with the following options:

"ALL"
B2:B8 (with "B2:B8" given literally as text)
"Other"

So how do I enter the source to combine strings and cell references as options?

Thanks for any help.

 

[pgc01]

Hi

You cannot combine the strings and cell references directly.

You can copy the all the values to a contiguous range and use that range in the Data Validation.

 

[Kelvin Stott]

OK, good to know, thanks. Saves me fiddling about for ages trying to get it to work.

K.