Here's one way (bit convoluted):

Highlight the cells you want to change, then:

CTRL-H (Find/Replace):
Find what: =
Replace with: xyz=
Click Replace All

(This changes the formulae to text strings so that you don't get
errors when you do a partial replace). Keeping the same highlighted
cells:

CTRL-H
Find what: (
Replace with: (INDIRECT("
Click Replace All

CTRL-H
Find what: )
Replace with: "))
Click Replace All

CTRL-H
Find what: xyz=
Replace with: =
Click Replace All

This last one changes those text strings back to formulae. You might
prefer to use something different to xyz if that string may appear in
your formulae - I know that Dave Peterson often recommends using $$$$.

I'm not sure what your formula does, though - what are you
concatenating to what?

Hope this helps.

Pete

On Feb 12, 1:37*am, julesgf wrote:
Hi all
I'm trying to use excel find and replace to replace this:
=CONCATENATE('Master List'!B1)
=CONCATENATE(INDIRECT("'Master List'!B1"))
in many cells where the B1 ref is not the same
so i need it to find
'Master List'!??
and replace with
INDIRECT("'Master List'!\1\2")
where \1 is the col ref and \2 is the row ref
easy in word but i'm totaly stuck in excel