Thread: taking the file extension out of the file name
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
wrkingurl wrkingurl is offline
external usenet poster
  
Posts: 5
Default taking the file extension out of the file name
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