software

I am trying to do a find and replace and am getting quot;formula is too longquot;
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 quot;, and managersquot; and trying to
replace it with quot;, and managesquot;. There are 800 lines I'd like to edit so
being able to do a quot;replace allquot; makes it much less time-consuming! Does
anyone know how to fix this?

Thanks!

gt; I am trying to do a find and replace and am getting quot;formula is too longquot;
gt; error message. I'm confused because the column I'm searching doesn't
contain
gt; formulas - just text. Also, the text I'm using in the find and replace box
gt; isn't very long - I'm using phrases such as quot;, and managersquot; and trying to
gt; replace it with quot;, and managesquot;. There are 800 lines I'd like to edit so
gt; being able to do a quot;replace allquot; makes it much less time-consuming! Does
gt; anyone know how to fix this?
gt;
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
Thanks Cliff. In response to your questions:

1. When I am doing a find only, I can search by values, formulas, or
comments. However, when I try to do find and replace, the only option it
gives me is to search by formulas - there are only blank lines below that
option.

2. All cells with the desired text are too long. If I am replacing text on a
cell-by-cell basis, it gives me the error message after I hit the Replace
button. If I try to use Replace All, it gives me the message after I hit the
Replace All button.

3. Yes, Search without Replace works fine.

Thanks!

Brook

3.
quot;news-server.insight.rr.comquot; wrote:

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


quot;BCBCquot; gt; wrote in message
...
gt; Thanks Cliff. In response to your questions:
gt;
gt; 1. When I am doing a find only, I can search by values, formulas, or
gt; comments. However, when I try to do find and replace, the only option it
gt; gives me is to search by formulas - there are only blank lines below that
gt; option.
gt;
gt; 2. All cells with the desired text are too long. If I am replacing text on
a
gt; cell-by-cell basis, it gives me the error message after I hit the Replace
gt; button. If I try to use Replace All, it gives me the message after I hit
the
gt; Replace All button.
gt;
If you manually go into the cell and do your edit, do you get the 'too long'
error? or just with 'search/replace'?
If you get it even manually you may have to split the text into two cells.
How long is the text?

Cliff
I can go into any of the cells and edit the text (adding to it or taking away
from it) with normal results. The number of characters in the cells range
from 850 to ???

quot;news-server.insight.rr.comquot; wrote:

gt;
gt; quot;BCBCquot; gt; wrote in message
gt; ...
gt; gt; Thanks Cliff. In response to your questions:
gt; gt;
gt; gt; 1. When I am doing a find only, I can search by values, formulas, or
gt; gt; comments. However, when I try to do find and replace, the only option it
gt; gt; gives me is to search by formulas - there are only blank lines below that
gt; gt; option.
gt; gt;
gt; gt; 2. All cells with the desired text are too long. If I am replacing text on
gt; a
gt; gt; cell-by-cell basis, it gives me the error message after I hit the Replace
gt; gt; button. If I try to use Replace All, it gives me the message after I hit
gt; the
gt; gt; Replace All button.
gt; gt;
gt; If you manually go into the cell and do your edit, do you get the 'too long'
gt; error? or just with 'search/replace'?
gt; If you get it even manually you may have to split the text into two cells.
gt; How long is the text?
gt;
gt; Cliff
gt;
gt;
gt;

I think I saw a post by Jan Karel Pieterse that his newest FlexFind will avoid
this problem:

www.oaltd.co.uk/MVP/

If you want to mess around with your own macro:
groups.google.co.uk/groups?th...apeXSPAM.c om

If you're new to macros, you may want to read David McRitchie's intro at:
www.mvps.org/dmcritchie/excel/getstarted.htm

BCBC wrote:
gt;
gt; I am trying to do a find and replace and am getting quot;formula is too longquot;
gt; error message. I'm confused because the column I'm searching doesn't contain
gt; formulas - just text. Also, the text I'm using in the find and replace box
gt; isn't very long - I'm using phrases such as quot;, and managersquot; and trying to
gt; replace it with quot;, and managesquot;. There are 800 lines I'd like to edit so
gt; being able to do a quot;replace allquot; makes it much less time-consuming! Does
gt; anyone know how to fix this?
gt;
gt; Thanks!

--

Dave Peterson

Thanks to both of you!

quot;Dave Petersonquot; wrote:

gt; I think I saw a post by Jan Karel Pieterse that his newest FlexFind will avoid
gt; this problem:
gt;
gt; www.oaltd.co.uk/MVP/
gt;
gt; If you want to mess around with your own macro:
gt; groups.google.co.uk/groups?th...apeXSPAM.c om
gt;
gt; If you're new to macros, you may want to read David McRitchie's intro at:
gt; www.mvps.org/dmcritchie/excel/getstarted.htm
gt;
gt; BCBC wrote:
gt; gt;
gt; gt; I am trying to do a find and replace and am getting quot;formula is too longquot;
gt; gt; error message. I'm confused because the column I'm searching doesn't contain
gt; gt; formulas - just text. Also, the text I'm using in the find and replace box
gt; gt; isn't very long - I'm using phrases such as quot;, and managersquot; and trying to
gt; gt; replace it with quot;, and managesquot;. There are 800 lines I'd like to edit so
gt; gt; being able to do a quot;replace allquot; makes it much less time-consuming! Does
gt; gt; anyone know how to fix this?
gt; gt;
gt; gt; Thanks!
gt;
gt; --
gt;
gt; Dave Peterson
gt;