Creating names under Formulas>Define Name issue

[Devonair]

Hi Everyone,

I have a problem, I tried creating a new Define Name but the name I'm gonna use look like this...
SBC(D255)

but when I create, it says an error The name you entered is not valid. Is there a way for me to use these ( ).?

Thanks for your help

 

[My Aswer Is This]

You cannot use numbers and numerous other symbols for a named range. Stick with Letters.

 

[Fluff]

You cannot use () as part of a name, you can use numbers as long as the name is not a valid range reference.
So something like SBC255 is no good, but SBCD255 or SBC_255 is fine.
Have a look here https://contexturesblog.com/archives/2017/12/07/what-are-the-rules-for-excel-names/

 

[My Aswer Is This]

When I try using a named Range like 123456 I get a error.

You cannot use () as part of a name, you can use numbers as long as the name is not a valid range reference.
So something like SBC255 is no good, but SBCD255 or SBC_255 is fine.
Have a look here https://contexturesblog.com/archives/2017/12/07/what-are-the-rules-for-excel-names/

 

[Devonair]

Thanks for you quick answer...

The reason I need this code, is that this in an item and on this item SBC(D255) there is another items underneath it.

Usually our item is ADD234 ADD001.. I don't have issues making it to a list.

Is there a way for me to clean this SBC(D255) with a excel comman remove all symbols and make it look like this SBCD255 then I can probably start with there.


thanks

 

[Fluff]

@MAIT
A named range cannot begin with a number, hence you get an error.
@Devonair
Not quite sure what you are saying.