Thread: taking the file extension out of the file name
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Jim Thomlinson Jim Thomlinson is offline
external usenet poster
  
Posts: 5,939
Default taking the file extension out of the file name
You can use the substitue formula something like this...

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

Jim Thomlinson


"wrkingurl" wrote:

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.

--
thanks,
Wurkingurl
Reply With QuoteReply With Quote