news-server.insight.rr.com
Guest
Re: The Formula is Too Long
> I am trying to do a find and replace and am getting "formula is too long"
> error message. I'm confused because the column I'm searching doesn't
contain
> formulas - just text. Also, the text I'm using in the find and replace box
> isn't very long - I'm using phrases such as ", and managers" and trying to
> replace it with ", and manages". There are 800 lines I'd like to edit so
> being able to do a "replace all" makes it much less time-consuming! Does
> anyone know how to fix this?
>
very tough to tell, it could be lots of things. It sounds like you need to
go through the troubleshooting process to narrow it down.
Did you try search/replace on values instead of formulas?
Does it tell you which cell is too long?
Does 'search' without 'replace' work?
I've seen the error before but not for any single reason. As long as this
is not a known bug, or common problem, you'll have to provide more info.
cliff
Bookmarks