| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| file format or file extension is not valid...error message | Excel Discussion (Misc queries) | |||
| Additional file with no extension created during File Save As proc | Excel Discussion (Misc queries) | |||
| how i open a file XLS extension[ exelspreadsheet file] | Excel Worksheet Functions | |||
| .dat file extension | Excel Discussion (Misc queries) | |||
| I need to download an exel spreadsheet file. (file extension :xls) | Excel Discussion (Misc queries) | |||
Hybrid Mode
