Thread: Using wildcard characters in find & replace
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Tola Tola is offline
external usenet poster
  
Posts: 4
Default 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 ?
Reply With QuoteReply With Quote