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

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

taking the file extension out of the file name
 

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!
--
thanks,
Wurkingurl


"Jim Thomlinson" wrote:

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

taking the file extension out of the file name
 

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


"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