Remove File Extensions From a List of Files

J

justinfoote

I have a multiple very long lists containing file names. I'd like to
strip the extensions off and compare names together.
Does anyone know of a way to make
xxxxx.prt
turn into
xxxxx

Thanks
 
B

Beege

[email protected]> wrote in message
I have a multiple very long lists containing file names. I'd like to
strip the extensions off and compare names together.
Does anyone know of a way to make
xxxxx.prt
turn into
xxxxx

Thanks
Click to expand...

If you have all files with a three letter extension, you can use a
combination of LEFT() and LEN() to show the file minus the extension...

I'll check back to see if you've figured it out.

Beege
 
Top