my excel formulas are too long to execute find and replace

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to do a find and replace on a large number of long formulas that
I have created, but I get an error message "formula is too long"
 
I'm guessing your question is: Why is that happening?

It seems like the "old text" is being replaced by longer text that causes
the number of characters to exceed Excel's limit for formulas (1,024 chars if
I recall correctly).

The formula sizes need to be reduced.

A couple possible solutions:
replace long references with shorter range names
remove redundant parentheses

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

IF AND Nested Functions - Formula Not Working 0
How do I find & replace pieces of a formula? 4
Rounding cents 3
Formula too long 2
Formula Is Too Long 1
formula too long? 2
EXCEL - IF(IFERROR(VLOOKUP question 0
Creating large formulas in Excel 7

Back
Top