I can't think of how to explain this question so I'll just use an example:

Using the find and replace command. I want to find < 'Worksheet1'!A* > and
replace it with < INDIRECT("'Worksheet1!A*") >. In the example the find
command is of course using " * " for a wildcard. the problem I'm having is I
need whatever that cell number is to remain the same during replacement. For
example, when it finds < 'Worksheet1'!A2 > it should replace it with <
INDIRECT("'Worksheet1!A2") > and when it finds < 'Worksheet1'!A3 > it should
replace it with < INDIRECT("'Worksheet1!A3") >, etc. Is there a symbol/key
command that I can use to tell excel to search using the wild card but
replace the cell reference with the same cell reference it finds but also add
in the INDIRECT command?

You can just do
'Worksheet1'!A
and replace with
INDIRECT("'Worksheet1!A

--
-John
Please rate when your question is answered to help us and others know what
is helpful.


"rgilbreath" wrote:

> I can't think of how to explain this question so I'll just use an example:
>
> Using the find and replace command. I want to find < 'Worksheet1'!A* > and
> replace it with < INDIRECT("'Worksheet1!A*") >. In the example the find
> command is of course using " * " for a wildcard. the problem I'm having is I
> need whatever that cell number is to remain the same during replacement. For
> example, when it finds < 'Worksheet1'!A2 > it should replace it with <
> INDIRECT("'Worksheet1!A2") > and when it finds < 'Worksheet1'!A3 > it should
> replace it with < INDIRECT("'Worksheet1!A3") >, etc. Is there a symbol/key
> command that I can use to tell excel to search using the wild card but
> replace the cell reference with the same cell reference it finds but also add
> in the INDIRECT command?