Excel 2013: Concatenate 2 names in name manager

Question

I use data validation to create dropdowns in two cells. The dropdowns contain data of names in the name manager. I need to create an other name in the name manager who contains the concatenation of two first (format: name1 + ' - ' + name2) in order to apply it in an other dropdown. How to do that ?

Thank you in advance

Answer 1

Solution - Create a third column in your excel sheet that concatenates the Columns for you and use this as the source in your name manager range.