Using wildcard characters in find & replace
Hi Luke,
I tried the following:
Find:
+'[BBB.xls]??????????
Replace with:
+'[CCC.xls]??????????
Message: Excel found no data to replace
The formula contains a link to the one file twice and I want to replace one
of the links with another link. Therfor can not use Data,edit links, change
source.
Can do what you suggest but means I will have to do so cell by cell and the
change in the link is required in multiple cells on multiple sheets !
"Luke M" wrote:
They are recognized, but you may not be applying them correctly. Also, if
you search for a wildcard, you'd have to define what to replace that
wildcard with! Perhaps you can do:
Find:
+'[BBB.xls]Sheet1'!A7+
Replace with:
+'[CCC.xls]Sheet1'!A7+
--
Best Regards,
Luke M
"Tola" wrote in message
...
How do I change a range of Formula linked to 3 other files ?
Example:
Cell Reference:
A7:='[AAA.xls]Sheet1'!A7+'[BBB.xls]Sheet1'!A7+'[BBB.xls]Sheet1'!A7
A8:='[AAA.xls]Sheet1'!A8+'[BBB.xls]Sheet1'!A8+'[BBB.xls]Sheet1'!A8
Want to change one of the references to '[BBB.xls] to '[CCC.xls] using
wildcard characters but * and ? does not seam to be regognized in find and
repalce ?
.
|