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