Hi Govind.......

I tried your INDIRECT formula and it worked ok, after I enclosed the CLEAN
portion as (CLEAN(c6)) in parenthesis, but as Dave eluded, only if the File
is open.........I suppose I could "open the file, obtain the data, and close
the file", but I would rather not have to do that unless absolutely
necessary.........

Any other ideas, please?

Vaya con Dios,
Chuck, CABGx3



"Govind" wrote:

Hi,

use

=INDIRECT("'["&CLEAN(C6)&"_"&B6&".xls]Sheet1'!$A9")

Regards

Govind.

CLR wrote:
Hi All........

I am trying to concatenate two cells together to form a filename in a
link............no joy, .......all I get is "That filename is not
valid"........

=[clean(c6)&"_"&b6.xls]Sheet1!$A9

C6 is a name, as Jones, Fred
B6 is a string as R1938

The filename I 'm looking for is Jones,Fred_R1938.xls and it does
exist........and of course works if I hard code the filename into the
formula........

=clean(c6)&"_"&b6 works fine in a test of that standalone part, but not in
the link formula

Any help would be appreciated........

Vaya con Dios,
Chuck, CABGx3