Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Using wildcard characters in find & replace
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 ? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Using wildcard characters in find & replace
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 ? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 ? . |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Using wildcard characters in find & replace
To explain the problem better:
Have 3 workbooks with multiple sheets which is consolidated into 1 workbook. The links to the 3 workbooks had to be changed and was done with the "data, edit links, change source" command but one of the the links was mistakenly duplicated resulting in the info below. File was saved so can not undo. Formula: :='[AAA.xls]Sheet1'!A7+'[BBB.xls]Sheet1'!A7+'[BBB.xls]Sheet1'!A7 Want to change it to: :='[AAA.xls]Sheet1'!A7+'[BBB.xls]Sheet1'!A7+'[CCC.xls]Sheet1'!A7 The rest below might make more sense now ! "Tola" wrote: 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 ? . |
#5
|
|||
|
|||
Quote:
What I understand is that, your are looking to change the existing formulae from BBB to CCC in the third summation part A7:='[AAA.xls]Sheet1'!A7+'[BBB.xls]Sheet1'!A7+'[BBB.xls]Sheet1'!A7 1. Place the curosr in A7 Cell 2. Goto Formulae bar 3. Edit the formulae manually in third summation from BBB to CCC 4. Drag the formulae from Cell A7 to till end
__________________
Thanks Bala |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Use of Wildcard characters with replace | Excel Discussion (Misc queries) | |||
find & replace - digit wildcard | Excel Discussion (Misc queries) | |||
Find and Replace Command Using Wildcard Help | Excel Discussion (Misc queries) | |||
Find Replace Wildcard | New Users to Excel | |||
How do you find and replace a Wildcard character in Excel? | Excel Discussion (Misc queries) |