Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Find and Replace Command Using Wildcard Help
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Find and Replace Command Using Wildcard Help
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Find Replace Wildcard | New Users to Excel | |||
How to cancel a find & replace command "midstream"? | Excel Worksheet Functions | |||
find a character and replace with a command in Excel | Excel Discussion (Misc queries) | |||
How do you find and replace a Wildcard character in Excel? | Excel Discussion (Misc queries) | |||
Excel has a "Find Next" command but no "Find Previous" command. | Excel Discussion (Misc queries) |