Find and Replace. Formula Too Long Error Message.

[littlealk4]

I am using Microsoft Excel 2003. Every time I do a Find and Replace, I get an
error message that simply says, "Formula Too Long." I can Find all instances
that I want to replace, but it won't let me Replace any of them. Can some one
tell me why I am getting the message and also how to fix it? Thanks!

 

[Jan Karel Pieterse]

Hi Littlealk4,

I am using Microsoft Excel 2003. Every time I do a Find and Replace, I get an
error message that simply says, "Formula Too Long." I can Find all instances
that I want to replace, but it won't let me Replace any of them. Can some one
tell me why I am getting the message and also how to fix it?

Because excel always replaces in formulas (even if it is text) and formulas can
be no longer than 1024 characters.

My Flexfind should help you with this:

www.jkp-ads.com/officemarketplaceff-en.asp

Regards,

Jan Karel Pieterse
Excel MVP
http://www.jkp-ads.com
Member of:
Professional Office Developer Association
www.proofficedev.com