Is there a way to remove the underscore from a referenced cell in a named range?
See attached - Well for some reason I can't upload a file. Hope this makes sense
Here is my reference list that is the primary pulldown. I understand how to use the indirect function with substitute to replace the _ with a space. Can't us a formula for the primary/reference range.
Big_Stuff
Medium_Stuff
Bookmarks