Show file name in worksheet, without path name - =FILENAME(). Cell("filename") gives path etc. want only filename
Have alternative to the Cell("filename") so that only the file name shows in the cell, ie without lengthy path name etc.
Tony Valko commented
Yes, we need a SIMPLE function to return the file name.
By default is should return just the file name without file extension.
It should have optional arguments for the full path and file extension.
=FILENAME([Include Path=1],[Include Extension=1])
I HATE that save or save as file operations don't refer automatically to the file name just closing. Also, opening files starts with a search...NONSENSE!! The last files used should be readily listed!! Used to be...hate the revisions!!