Name Manager and Spaces

Nicole6

New Member
Joined
Aug 29, 2019
Messages
1
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!
 

Some videos you may like

Excel Facts

Round to nearest half hour?
Use =MROUND(A2,"0:30") to round to nearest half hour. Use =CEILING(A2,"0:30") to round to next half hour.

DanteAmor

Well-known Member
Joined
Dec 3, 2018
Messages
10,208
Office Version
2007
Platform
Windows
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

Well-known Member
Joined
Mar 11, 2015
Messages
5,267
Office Version
365
Platform
Windows
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
 

Forum statistics

Threads
1,089,642
Messages
5,409,489
Members
403,266
Latest member
HMR120

This Week's Hot Topics

Top