# How to Clean up Excel Sheet

#### mn072065

##### New Member
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

### 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
Are you looking for this?
=LEFT(A1,FIND(".",A1)-1)

#### mn072065

##### New Member
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

##### MrExcel MVP, Moderator
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.