I could do that but the workbook is complex enough already. The formulas are
long due to long pathnames in references, not due to complex operations, and
they work error-free as is. But I need to change the pathnames. Do you know
if there is a limit on number of characters or something else that is
specific to search & replace?

"Farhad" wrote:

I need to see your formula and see if i can shrink it but the final sugestion
would be to split your formula in 2 cells i mean do half of your formula in
one cell and do the rest in another cell.

Thanks
--
Farhad Hodjat


"DAE" wrote:

How can I fix a "Formula is too long" error that occurs during search &
replace operations? Thanks.