Length of a formula

  • Thread starter Thread starter phowe43
  • Start date Start date
P

phowe43

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?
 
Try specifications and limits in Excel help.

For Excel 2003:
"Length of formula contents 1,024 characters "
 
Just to add to David's response...

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