I am creating dependent drop down list in Excel using Data validation and Name Manager and the function Indirect.
My problem is that the Name Manager doesn't allow to have space when defining a new name. Based on Microsoft,this is not allowed and they suggest to put a (_) or (.) instead.
Define and use names in formulas
Is there any way to bypass this as I have many names having spaces to put them in the drop down menus.