But I need to insert a $ after the J. I've tried
Search For: ='Grant Project 1'!J*
Replace With: ='Grant Project 1'!J$*
but I get an error message...?


"db" wrote:

If you want all the references to point to 'Grant Project 1'!J314, and all
the references are the same up to the '3' (i.e. you don't have anything like
'Grant Project 1'!J884) you can use this:

Search For: 'Grant Project 1'!J3*
Replace With: 'Grant Project 1'!J314

If that '3' does change, just change what you search for to 'Grant Project
1'!J*

Basically put the asteric after the spot in the formula you don't want to
change.
--
Regards,
db


"koskyil" wrote:

I have the following formula:
='Grant Project 1'!J314
but it's repeated in a column, each time with a different number
(i.e. ='Grant Project 1'!J314, ='Grant Project 1'!J317, ='Grant Project
1'!J320...)
and I want to replace each occurance with
='Grant Project 1'!J$314
Is there a way to use the replace tool to insert the '$' by using wildcards
in place of the numbers?

Thanks in advance.