link the file name

[bokals]

hi.. I just want to know how am i going to link my file name into a cell? It is possible in header/footer but I dont know in spreadsheet.
Thank you for your help.

[windknife]

Try

=CELL("filename")

or

Please Login or Register  to view this content.

committed with Ctrl+Shift+Enter

HTH,
windknife

[bokals]

Try

=CELL("filename")

or

Please Login or Register  to view this content.

committed with Ctrl+Shift+Enter

HTH,
windknife

Dear windknife,

This is not what Im trying to do, I need only the certain file name of the spreadsheet. Your formula gave me the whole path of the file. Thanks anyway

[windknife]

How about this?

Please Login or Register  to view this content.

Committed with Ctrl+Shift+Enter

HTH,
windknife

[bokals]

How about this?

Please Login or Register  to view this content.

Committed with Ctrl+Shift+Enter

HTH,
windknife

Dear windknife,

Yes your formula works... however there is one more thing that I want to remove. There is an .xls after the name, it is possible to remove this file extension. Thanks again for your help

[windknife]

Try this,

Please Login or Register  to view this content.

Remember to commit with Ctrl+Shift+Enter.

HTH,
windknife

[bokals]

Try this,

Please Login or Register  to view this content.

Remember to commit with Ctrl+Shift+Enter.

HTH,
windknife

Dear windknife

The file name is not complete. The 6 characters are missing with this formula.

[windknife]

Try this,

Please Login or Register  to view this content.

committed with CSE

You can also see attached file.
windknife

[bokals]

Try this,

Please Login or Register  to view this content.

committed with CSE

You can also see attached file.
windknife

Dear windknife

Thank you very much for your help. My problem is solved... Bless you.