| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
find and replace \n wildcards like word
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Find and Replace with wildcards? | Excel Discussion (Misc queries) | |||
| Why not accept wildcards for REPLACE as well as FIND ? | Excel Discussion (Misc queries) | |||
| Find 1 word and replace it and leave the leading zero | Excel Discussion (Misc queries) | |||
| How can I use find and replace to delete a word in Excel? | Excel Discussion (Misc queries) | |||
| Word Automation - Find/Replace | Excel Discussion (Misc queries) | |||
Threaded Mode
