Excel Formula Length

[Guest]

How do I extend the amount of characters an Excel formula will allow me to
enter?

 

[Jason Morin]

You don't, but you can used defined names to shorten your
formulas. To learn how to implement them, see:

http://www.cpearson.com/excel/named.htm
http://www.xldynamic.com/source/xld.Names.html

HTH
Jason
Atlanta, GA

 

[Bernard Liengme]

When you use 'specification's and look up formula length Help tells you that
the maximum length of a formula is 1024 characters. If there was some way of
making it more, Help would say it was some other number.

Generally if a formula is too long you need to simplify it using: 1) more
that one cell to achieve the result, or 2) restructuring the formula (e,g
using lookups in place of long IFs, etc.
We would need more info to be of any help
best wishes

 

[Biff]

Hi!

The limit is 1024 chars. That's a long formula!

There's no way to get more than that but what you should
do is try to reduce the length of the formula.

One common issue that leads to this is the use of long
paths and sheet names as references. If that's not an
issue then perhaps you can split your one long formula
into several smaller intermediate formulas.

Biff