How to Clean up Excel Sheet

mn072065

New Member
Joined
Feb 21, 2007
Messages
40
Some help please. I have around 400 movies, i was lucky to dump into an excel the folder structure with a program. Now this is waht i have

88 Minutes (2008).iso
88 Minutes (2008).jpg
88 Minutes (2008).nfo
88 Minutes (2008).png
88 MINUTES-disc.png
88 MINUTES-fanart.jpg
88 MINUTES-fanart1.jpg
88 MINUTES-fanart2.jpg
88 MINUTES-landscape.jpg
88 MINUTES-logo.png
88 MINUTES-poster.jpg

what i want is to just have the movie name for example on this one 88 minutes (2008) and thats it, this way i can dump this into another program called movie collectorz and categorize them. Any help would greatly be appreciated. Thanks
 

Some videos you may like

Excel Facts

Lock one reference in a formula
Need 1 part of a formula to always point to the same range? use $ signs: $V$2:$Z$99 will always point to V2:Z99, even after copying

Peter_SSs

MrExcel MVP, Moderator
Joined
May 28, 2005
Messages
44,443
Office Version
365
Platform
Windows
Are you looking for this?
=LEFT(A1,FIND(".",A1)-1)
 

Peter_SSs

MrExcel MVP, Moderator
Joined
May 28, 2005
Messages
44,443
Office Version
365
Platform
Windows
I placed formula in column b, still not giving me just the one movie with year, thanks
Then I am probably not understanding quite what you have or what you want. Could you give us another set of sample data, still keep it fairly small but big enough to show us the sort of variety you have in your data and also give us the expected result(s) from that sample data?
Even better if you could use one of the options suggested from the link in my signature block below so that we can
a) See exactly what rows and columns the data occupies and the same for the results.
b) Copy that sample data to our worksheets to test our ideas.
 

Watch MrExcel Video

Forum statistics

Threads
1,095,813
Messages
5,446,648
Members
405,413
Latest member
AlainCar

This Week's Hot Topics

Top