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