Length of a formula
 

I'm not great with Excel or formulas and I'm trying something that may be
over my head...so any help would be great. I'm basically doing an "IF"
formula with a long string behind it. Seems like I'm running out of space and
it won't allow me to complete the string that I need.

Is there a character limit?

Length of a formula
 

Try specifications and limits in Excel help.

For Excel 2003:
"Length of formula contents 1,024 characters "
--
David Biddulph

"phowe43" wrote in message
...
I'm not great with Excel or formulas and I'm trying something that may be
over my head...so any help would be great. I'm basically doing an "IF"
formula with a long string behind it. Seems like I'm running out of space
and
it won't allow me to complete the string that I need.

Is there a character limit?

Length of a formula
 

Just to add to David's response...

That's 1024 characters when you measure the formula using R1C1 reference
style--not A1 reference style.

David Biddulph wrote:

Try specifications and limits in Excel help.

For Excel 2003:
"Length of formula contents 1,024 characters "
--
David Biddulph

"phowe43" wrote in message
...
I'm not great with Excel or formulas and I'm trying something that may be
over my head...so any help would be great. I'm basically doing an "IF"
formula with a long string behind it. Seems like I'm running out of space
and
it won't allow me to complete the string that I need.

Is there a character limit?

--

Dave Peterson