Find and Replace. Formula Too Long Error Message.

  • Thread starter Thread starter littlealk4
  • Start date Start date
L

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!
 
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?
Click to expand...

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
 
Back
Top