| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Copy all text in a string prior to the last period...
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Copy all text in a string prior to the last period...
On Thu, 31 Mar 2011 00:48:08 GMT, Andrew Bell wrote:
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 A1: Data B1: =LEFT(A1,FIND(CHAR(1),SUBSTITUTE(A1,".",CHAR(1),LE N(A1)-LEN(SUBSTITUTE(A1,".",""))))-1) |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Copy all text in a string prior to the last period...
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) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Change 3 letter text string to a number string | Excel Discussion (Misc queries) | |||
| Search text string for ssn and copy to new column | Excel Discussion (Misc queries) | |||
| Copy Text String from between () | Excel Worksheet Functions | |||
| I need to change cell string lenths prior to upload into sql table | Excel Worksheet Functions | |||
| Copy a string text to cell if another cell not empty | Excel Discussion (Misc queries) | |||
Hybrid Mode
