Returning list of file names in column. Would like to remove file ext. from returned list.

Hello,

I've been trying a few different ways to get my returned list of file names to remove the ".xlsx" extension from it's result, but am having some trouble.

Does anybody know of an easy way to do this?

Below describes how I'm going about getting my list of file names.

Please Login or Register  to view this content.

"FN" refers to a saved name path which has the below code referencing it...

Please Login or Register  to view this content.

I'm just trying to get my returned list of file names to not show the ".xlsx" portion of the file name.


Thank you in advance for any help!

Hello Sean,

Thank you for your prompt reply.

I've tried implementing a SUBSTITUTE function into the INDEX of my formula before, but to no avail.

What I have is a table which in column A contains the formula below:

Please Login or Register  to view this content.

That formula is telling that entire column (A) to return the names of files as they are created in another folder.

Once that file name is placed there, the rest of the columns to the right of col A, then use that file name to locate which file to pull the data from for it's adjacent rows.

I'm looking to try and remove the ".xlsx" portion of the returned file name really only for cosmetic reasons. Just wondering if it is possible to do so by means of incorporating a method/function into what I've got going already?

Well, I figured it out.

Please Login or Register  to view this content.

Above is my result in case somebody else is looking for a resolution to this in the future.