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

's Computer Specifications

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

's Computer Specifications

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

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Match Prior Billing Period Closing Balance to New Billing Period O	Dave M	Microsoft Access	3	9th Sep 2009 04:37 PM
The timeout period elapsed prior to obtaining a connection from th	John Staggs	Microsoft Dot NET	7	27th Mar 2008 04:56 PM
The timeout period elapsed prior to obtaining a connection...	=?Utf-8?B?Y2FzaGRlc2ttYWM=?=	Microsoft C# .NET	2	27th Jul 2007 02:42 PM
Reached Logon Limit prior to Grace Period	=?Utf-8?B?c3RhY3luYWd5dmFyeQ==?=	Microsoft Windows 2000 Terminal Server Applications	3	22nd Mar 2005 10:30 PM
Querying records prior to a certain period	Denyse	Microsoft Access Queries	1	14th Jul 2003 02:22 PM