How to Clean up Excel Sheet

[mn072065]

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

 

[Peter_SSs]

Are you looking for this?
=LEFT(A1,FIND(".",A1)-1)

 

[mn072065]

Are you looking for this?
=LEFT(A1,FIND(".",A1)-1)

I placed formula in column b, still not giving me just the one movie with year, thanks

 

[Peter_SSs]

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.