| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
my excel formulas are too long to execute find and replace
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" |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
my excel formulas are too long to execute find and replace
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 "jmh33" wrote: 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" |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Find and replace should work in Excel text boxes | Excel Discussion (Misc queries) | |||
| find and replace path name in Excel cells containing hyperlink | Excel Discussion (Misc queries) | |||
| find and replace links in Excel 2003 | Excel Worksheet Functions | |||
| Find and replace Excel, Office pro 2003 | Excel Discussion (Misc queries) | |||
| macro to Find Replace in Excel | Excel Discussion (Misc queries) | |||
Hybrid Mode
