View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Dave Peterson[_2_] Dave Peterson[_2_] is offline
external usenet poster
 
Posts: 420
Default Use concatenated String as input to Data Validation List

Are you using a range as the source of the validation list?

If yes, you can use a formula in any of the cells in that range to concatenate
the values from any other cells.

On 07/26/2010 09:45, KevinC wrote:
Hello all,

I would like to use a concetenated string to populate a data
validation list.

Is this possible?

Regards,

Kevin


--
Dave Peterson