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

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
 
R

Rick Rothstein

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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to group records in a table 8
Return the text before a | in a text string 5
Formula to Pick Out Characters within a Text String 7
Finding a charcter in a text string 3
Extracting the last set of words from a text string 14
Timeout expired. The timeout period elapsed prior to completion ofthe operation or the server is no 12
The timeout period elapsed prior to obtaining a connection... 2
NEED TO FILL BLANK CELLS IN DATA WITH TEXT STRING 7

Top