I am trying to gather all text before the last period in
strings of text, for example I want to take everything
before the file extension below, and place that in a
new cell. Any thoughts how I can accomplish this? I
appreciate the help. Thanks.


x:\TRX0000070.ATT%0000001.pdf
x:\TRX0000070.ATT%0000002.xlsx
x:\TRX0000070.ATT%0000003.pdf
x:\TRX0000070.ATT%0000004.pdf

If your files are all named with the same structure that you showed us in
your sample names, then you can simply do this...

=LEFT(A1,25)

Rick Rothstein (MVP - Excel)