Spaces in Cell Range

[BurkeDad]

I am creating Dedicated pull downs and the I need to have spaces in the cell range name. Example - the primary pull down list is comprised of states - therefore for states like New Mexico, South Carolina, etc.... I will need to have a space included.
Any ideas? Thanks.

 

[kpark91]

I don't understand your question, could you elaborate more on it?
What your problem is and what you need.

 

[mikerickson]

you cannot have spaces in the name of a named range

perhaps you could used named ranges like South_Dakota and =INDIRECT(SUBSTITUTE(A1, " ", "_"))

 

[BurkeDad]

Here is the issue. I am creating dependent lists and I need the cell range names to be sperated. Reason is that in the form where the user selects the state, the name appears on the report. Therefore, i cannot have the state's name as a single name.

 

[mikerickson]

if you are using named ranges, you cannot have spaces in their names.

My idea is to match what the user sees (with spaces) to a named range that has underscore instead of spaces.

Its a fairly direct approach, but the details of its implementation is heavily dependent on how things are set up.

 

[BurkeDad]

I tried the "substitute" formula and it did not work.

 

[BurkeDad]

Thanks for suggestion Mike. I included the underscore inthe name and it does not look too bad in the form.

Thanks for the help all.