Copy all text in a string prior to the last period...

  • Thread starter Thread starter Andrew Bell
  • Start date Start date
A

Andrew Bell

Hello,

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
 
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
Click to expand...

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)
 
Back
Top