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 ???

"news-server.insight.rr.com" wrote:


"BCBC" wrote in message
...
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.

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