Nope. Names can't contain those characters.

Maybe you can use Debra Dalgleish's technique:
http://contextures.com/xlDataVal02.html#TwoWord

She only cleans up space characters, but maybe you could modify it for your
names.

zzxxcc wrote:

When I name a range of cells by InsertNameCreateTop Row and the cell value
in the top row is: "Wrenches, 1/2" square" etc., the name is automatically
changed to "wrenched_1_2__square" and so on. It is not identical to the cell
/ column heading. When I then use ValidationList=Wrenches, 1/2" square, the
list can not be found. When I rename the cell with no spaces or odd signs, it
works.

Is there a way around the renaming? I would like to keep the signs like / &
" # in the cell range name.
--
Thanks

--

Dave Peterson