Excel Formula Length
 

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

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

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

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
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Matt" wrote in message
...
How do I extend the amount of characters an Excel formula will allow me to
enter?

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

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