Excel Dependent Data Validation tables naming convention -

[Marshall0901]

Looks like the Excel table naming convention for dependent data validation, requires the table name to not have any spaces and the only special characters allowed are underscore _ and the period.  Is this correct?

[#2 · Accepted solution]

@Marshall0901 

Yes. See Rename an Excel table 

[#3]

@Marshall0901 

Broadly, what you say about the naming convention for defined names is correct, but don't forget that what you think of as a letter or the alphabet and what the average Greek may consider to be a letter might differ.  In practice, many Unicode characters also work within names.  

Thus, should you choose, you could name a Table or a formula

←Λ³∕

and it will work.

Note: The ∕ is fraction separator, not the ASCII slash operator.

[#4]

@Peter Bartholomew 

Thank you Peter.  Your response is very helpful.  Have a safe & great weekend.

Best Regards,

Marshall

[#5]

@Hans Vogelaar 

Thank you Hans,

Your response is truly appreciated and very helpful.  Have a safe and fun weekend.

Best Regards,

Marshall