Name Boxes

[Winner_texas]

Does anyone know how to name a list so that we can include special characters? In the attached file, my objective is to have a list of numbers for a certain product. Lets say the product is called “ ˝” REG” .

In Column H, I have that list but I cant name the cells H3 to H26 as ˝” REG on top in the name box. I can have names like FRX or REG as in columns F and G. Select the cells from F3 to F26 and similarly from G3 to G26 and look at the name box.

Finally I want to be able to chose a product, lets say, ˝” REG in the Column A and display the list in Column B. The file already has that code. The problem is with the name boxes. Thanks,

HK

[ChemistB]

I don't think it's possible. I tried using Excels "Create Name" menu option with ˝Test in my left column and it returned "test" as the name. Also, defined names cannot have spaces.

ChemistB