Invalid define names

[Noreaster]

What are invalid letter combo's for Insert/Name/Define Excel 2003.

 

[Jon Peltier]

You can use letters, numerals, a few punctuation marks (. and _), but
nothing that looks like an operator (+ - * /). It must begin with a letter
(or maybe an underscore), and it must not be confused with a cell address,
like A1, B2, etc.

- Jon

 

[Noreaster]

That would explain why AC1147 wouldn't work but QM1147 did. You have a good
informative website, I had help to transpose your chart.
http://peltiertech.com/Excel/Charts/DynamicLast12.html

Thank you very much.

 

[David Biddulph]

An additional confusion is that you can use the single letters A, B, D, E,
F, ..., P, Q, S, T, U, ..., Z as names, but you can't use C or R.. The
create names facility will change these to C_ and R_.
This is presumably because of potential confusion with Columm and Row
designation.

 

[Noreaster]

I can use 2 letters, underscore and 4-6 numbers exa. ac_1148, qm_1148, pm_1147.
Should the letters be in caps or is it just a preference?

 

[Jon Peltier]

However you like.

- Jon

 

[ShaneDevenshire]

Hi,

Far less known RC is also and illegal range name.

In 2003 A1-IV65536 are illegal because they are cell addresses, in 2007 this
is A1-XFD1048576 because of the larger spreadsheet.