taking the file extension out of the file name

  • Thread starter Thread starter wrkingurl
  • Start date Start date
W

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.
 
You can use the substitue formula something like this...

=SUBSTITUTE(A1, ".jpg", "")
Where your file name is in cell a1.
 
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!
 
Select your range then hit Ctrl+H > Find what: .jpg > Replace with: leave it
blank > Replace All
 
Back
Top