Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
using wildcard characters for filenames in externally linked files
Hi,
Is it possible to use the wildcard character "?" in filenames used in formulas for external links? For example, I'd like to substitute the hjg with ??? ='C:\Excel\[hjgbella.xls]Sheet1'!$A$2 to end up with: ='C:\Excel\[???bella.xls]Sheet1'!$A$2 I can't make it work. If it can't work this way, can you think of another way I can do this? I don't think "left" or "mid" or "right" will help me either. What I need to be able to do is change these first three characters on several hundred similar files with managers initials. But as managers come and go, I need to change them without affecting the links. Thanks, Harold |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
WildCard Characters | Excel Worksheet Functions | |||
How do I use wildcard characters in Excel 2003 sumif formula? | Excel Worksheet Functions | |||
Using Wildcard characters in sumproduct | Excel Worksheet Functions | |||
Importing text files with mathematical characters | Excel Discussion (Misc queries) | |||
Why is a linked cell restricted to 256 characters | Excel Discussion (Misc queries) |