Find and Replace
 

When I try to do a find and replace, I get the following message: "Formula
too long"

This is the formula in the cell. I am replacing $O$ with $X$

='[2005 Budget - Marketing.xls]2005 bgt by season'!$M$14+'[2005 Budget -
Marketing.xls]2005 bgt by season'!$O$14+'[2005 Budget - Marketing.xls]2005
bgt by season'!$M$15+'[2005 Budget - Marketing.xls]2005 bgt by
season'!$O$15+'[2005 Budget - Marketing.xls]2005 bgt by season'!$M$17+'[2005
Budget - Marketing.xls]2005 bgt by season'!$O$17+'[2005 Budget -
Marketing.xls]2005 bgt by season'!$M$71+'[2005 Budget - Marketing.xls]2005
bgt by season'!$O$71+'[2005 Budget - Marketing.xls]2005 bgt by
season'!$M$89+'[2005 Budget - Marketing.xls]2005 bgt by season'!$O$89+'[2005
Budget - Marketing.xls]2005 bgt by season'!$M$101+'[2005 Budget -
Marketing.xls]2005 bgt by season'!$O$101+'[2005 Budget - Marketing.xls]2005
bgt by season'!$M$110+'[2005 Budget - Marketing.xls]2005 bgt by
season'!$O$110+'[2005 Budget - Marketing.xls]2005 bgt by
season'!$M$124+'[2005 Budget - Marketing.xls]2005 bgt by
season'!$O$124+'[2005 Budget - Marketing.xls]2005 bgt by
season'!$M$153+'[2005 Budget - Marketing.xls]2005 bgt by season'!$O$153

Don't know if this will help but I would take that chunk to a word processor
or text editor, do the find and replace there and then paste back the formula
Also make sure you didn't add a space together with the $X$ in the replace
process

a formula can be 1024 characters, copy the formula that works to a new
workbook
remove the equal sign at the beginning, use

=LEN(A1)

where a1 is the cell where you put the formula, now do the replace there and
see if the len formula will change

Regards,

Peo Sjoblom

"miket_jam" wrote:

When I try to do a find and replace, I get the following message: "Formula
too long"

This is the formula in the cell. I am replacing $O$ with $X$

='[2005 Budget - Marketing.xls]2005 bgt by season'!$M$14+'[2005 Budget -
Marketing.xls]2005 bgt by season'!$O$14+'[2005 Budget - Marketing.xls]2005
bgt by season'!$M$15+'[2005 Budget - Marketing.xls]2005 bgt by
season'!$O$15+'[2005 Budget - Marketing.xls]2005 bgt by season'!$M$17+'[2005
Budget - Marketing.xls]2005 bgt by season'!$O$17+'[2005 Budget -
Marketing.xls]2005 bgt by season'!$M$71+'[2005 Budget - Marketing.xls]2005
bgt by season'!$O$71+'[2005 Budget - Marketing.xls]2005 bgt by
season'!$M$89+'[2005 Budget - Marketing.xls]2005 bgt by season'!$O$89+'[2005
Budget - Marketing.xls]2005 bgt by season'!$M$101+'[2005 Budget -
Marketing.xls]2005 bgt by season'!$O$101+'[2005 Budget - Marketing.xls]2005
bgt by season'!$M$110+'[2005 Budget - Marketing.xls]2005 bgt by
season'!$O$110+'[2005 Budget - Marketing.xls]2005 bgt by
season'!$M$124+'[2005 Budget - Marketing.xls]2005 bgt by
season'!$O$124+'[2005 Budget - Marketing.xls]2005 bgt by
season'!$M$153+'[2005 Budget - Marketing.xls]2005 bgt by season'!$O$153

A trick that might help is to go to the workbook '2005 budget - marketing.xls'
and temporarily rename the worksheet to something shorter, like "X". Then save
the workbook under a new, shorter name, like 'Y'. Now you should be able to
edit the formula. When you've done that, reverse the worksheet and workbook
name changes.

On Wed, 26 Jan 2005 11:55:02 -0800, miket_jam
wrote:

When I try to do a find and replace, I get the following message: "Formula
too long"

This is the formula in the cell. I am replacing $O$ with $X$

='[2005 Budget - Marketing.xls]2005 bgt by season'!$M$14+'[2005 Budget -
Marketing.xls]2005 bgt by season'!$O$14+'[2005 Budget - Marketing.xls]2005
bgt by season'!$M$15+'[2005 Budget - Marketing.xls]2005 bgt by
season'!$O$15+'[2005 Budget - Marketing.xls]2005 bgt by season'!$M$17+'[2005
Budget - Marketing.xls]2005 bgt by season'!$O$17+'[2005 Budget -
Marketing.xls]2005 bgt by season'!$M$71+'[2005 Budget - Marketing.xls]2005
bgt by season'!$O$71+'[2005 Budget - Marketing.xls]2005 bgt by
season'!$M$89+'[2005 Budget - Marketing.xls]2005 bgt by season'!$O$89+'[2005
Budget - Marketing.xls]2005 bgt by season'!$M$101+'[2005 Budget -
Marketing.xls]2005 bgt by season'!$O$101+'[2005 Budget - Marketing.xls]2005
bgt by season'!$M$110+'[2005 Budget - Marketing.xls]2005 bgt by
season'!$O$110+'[2005 Budget - Marketing.xls]2005 bgt by
season'!$M$124+'[2005 Budget - Marketing.xls]2005 bgt by
season'!$O$124+'[2005 Budget - Marketing.xls]2005 bgt by
season'!$M$153+'[2005 Budget - Marketing.xls]2005 bgt by season'!$O$153

Now why didn't I think of that? <g

--
Regards,

Peo Sjoblom

(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)



"Myrna Larson" wrote in message
...
A trick that might help is to go to the workbook '2005 budget -
marketing.xls'
and temporarily rename the worksheet to something shorter, like "X". Then
save
the workbook under a new, shorter name, like 'Y'. Now you should be able
to
edit the formula. When you've done that, reverse the worksheet and
workbook
name changes.

On Wed, 26 Jan 2005 11:55:02 -0800, miket_jam
wrote:

When I try to do a find and replace, I get the following message: "Formula
too long"

This is the formula in the cell. I am replacing $O$ with $X$

='[2005 Budget - Marketing.xls]2005 bgt by season'!$M$14+'[2005 Budget -
Marketing.xls]2005 bgt by season'!$O$14+'[2005 Budget - Marketing.xls]2005
bgt by season'!$M$15+'[2005 Budget - Marketing.xls]2005 bgt by
season'!$O$15+'[2005 Budget - Marketing.xls]2005 bgt by
season'!$M$17+'[2005
Budget - Marketing.xls]2005 bgt by season'!$O$17+'[2005 Budget -
Marketing.xls]2005 bgt by season'!$M$71+'[2005 Budget - Marketing.xls]2005
bgt by season'!$O$71+'[2005 Budget - Marketing.xls]2005 bgt by
season'!$M$89+'[2005 Budget - Marketing.xls]2005 bgt by
season'!$O$89+'[2005
Budget - Marketing.xls]2005 bgt by season'!$M$101+'[2005 Budget -
Marketing.xls]2005 bgt by season'!$O$101+'[2005 Budget -
Marketing.xls]2005
bgt by season'!$M$110+'[2005 Budget - Marketing.xls]2005 bgt by
season'!$O$110+'[2005 Budget - Marketing.xls]2005 bgt by
season'!$M$124+'[2005 Budget - Marketing.xls]2005 bgt by
season'!$O$124+'[2005 Budget - Marketing.xls]2005 bgt by
season'!$M$153+'[2005 Budget - Marketing.xls]2005 bgt by season'!$O$153