Copy column but remove last few characters

Hi,

Very basic question for you. I have a column of data, (10,000 entries), a list of file names basically, e.g:

Mortality Project Executive Summary.pdf
RPP - AA rate and swaps.xls
Commodities.PPT presentation.ppt
Meeting Preparation 20090302.docx

etc...

Anywho the point is I want to remove the file extensions (and of course the "."s just before), but some obviously have 4 character extensions, some 3, some 2 etc... Some documents also have "."s in the file name that I do not want to remove, basically just working from the right keep removing until the first "." is removed.

So the final list wants to be:

Mortality Project Executive Summary
RPP - AA rate and swaps
Commodities.PPT presentation
Meeting Preparation 20090302

I know I should VBA it, but I want it all in the one spreadsheet and that's a bit above me. The document has about 30 other columns.

Many thanks,

Tim

Try:

Please Login or Register  to view this content.

copied down

where A1 contains first string to parse.