Name Manager and Spaces

[Nicole6]

Is it possible to have the name in the list show up on the sheet without the underscore? I have a dropdown menu in a cell which dictates what shows up in a drop down menu of another cell. I don't like how it looks with the underscores... is there a fix, or do I need to get over the cosmetics of it.
Thanks!

 

[DanteAmor]

which dictates what shows up in a drop down menu of another cell. !

On of other cell, do you have a formula?

maybe indirect then
=indirect(substitute(A2, " ", "_"))

 

[Yongle]

Get used to the underscore or avoid spaces in range names
Spaces are not permitted in range names

How are you using the names in your sheet ?
- you could use a formula or lookup table and convert the underscore to a space for cosmetic elegance