taking the file extension out of the file name

[wrkingurl]

I have a list of file names saved into excel that I need to compare to
another datafile. But I need to take the extensions out. They are all
different lengths.

Example:
ABC12-458.jpg
DEFTTR.5.jpg
LUG583ES457869.jpg
MAXREF45899-456.5.jpg

I want all of these names in a list without the .jpg at the end.

 

[Jim Thomlinson]

You can use the substitue formula something like this...

=SUBSTITUTE(A1, ".jpg", "")
Where your file name is in cell a1.

 

[wrkingurl]

Thanks Jim, it works great! I know this was probably a piece of cake for
you, but for those who aren't familiar with it, you're a lifesaver!

 

[Teethless mama]

Select your range then hit Ctrl+H > Find what: .jpg > Replace with: leave it
blank > Replace All