Names of workbook cell ranges not accepted with some signs

[Guest]

I have named a range of cells based on the top row in each column. S1:CR20.
Some names need signs like"/" and "-" and """, etc. This doesen work with
conditional validation. In A1 i use Validation>List> =S1:CR1. In B1 i use
Validation>List> =indirect(A1) and conditional formating. Is there a way to
make this work? I mean: To make Excel accept the different signs.

Also is there a way to delete all names in the workbook in one operation? I
am familiar with Insert>Name>Define>(select one)>Delete.

Thanks,
zzxxcc

 

[Guest]

One typical name is: Wrench with 1/2" square attachment.