create names of ranges for each cell in column with characters automatically

[KalilMe]

hello

firs of all it seems what I ask of it it 's impossible I try manually repeatedly but the excel inform me I can't name with this type of range so if it's possible what I want create ranges name automatically based on cells in COL A

my data in COL A like this

CODE
1000BS20
1000-BS
BS-1000
BS/1000-AT20

so if there is any way or alternative to overcome preventing EXCEL to do that

I appreciate that

thank for this a great forum

 

[Fluff]

None of those are valid names, have a look here Excel names and named ranges: how to define and use in formulas

 

[KalilMe]

it's useful this link but I have about 500 cells in COL A if I define name each cell it will take from me more time , is there way do that define the name each cells in COL A automatically ?

 

[Fluff]

I'm afraid I have no idea what you are asking.