If you want to replace only "2007Jan", select only the cells you want and
Find/Replace

--

Rodrigo Ferreira


"sadat" escreveu na mensagem
...
Hello,
My problem is: I use a very large
formula:=SUMPRODUCT(--(TEXT(F13:F59,"yyyymmm")="2007Jan"),J13:J59). and
the
formula is used in more than 1000 cells. but the month name and range
changes
according to row and column of every cell. How can I change the formula of
every cell without selecting each cell and editing manually? I would be
very
much thankful if anyone can help me with this problem.