H
Harold Good
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
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