Select specific text in cell
That works! Thank you very much
"Ron Rosenfeld" wrote:
On Fri, 15 Feb 2008 18:07:05 -0800, John Gregory
wrote:
The text strings are random length - file path names:
c:\sampledir1\filename - description
In this example, I want to get the string "filename", but I have many
directories, all with differnt length names.
c:\samplelongname2\filename345 - longer description
etc.
In all cases I want to get the text between the "/" and the "-". The right
and left functions do not work because the number of characters varies.
Any ideas
In your example, the - is surrounded by <space on both sides.
If this is the case in your strings, it would be more robust to look for that
sequence, than just for the "-".
With your string in A1, here is a formula that will extract the string that is
between the last "\" and the last "-" :
=TRIM(MID(A1,1+FIND(CHAR(1),SUBSTITUTE(A1,"\",CHAR (1),
LEN(A1)-LEN(SUBSTITUTE(A1,"\","")))),-1+FIND(CHAR(1),
SUBSTITUTE(A1,"-",CHAR(1),LEN(A1)-LEN(SUBSTITUTE(A1,"-",""))))
-FIND(CHAR(1),SUBSTITUTE(A1,"\",CHAR(1),LEN(A1)-
LEN(SUBSTITUTE(A1,"\",""))))))
--ron
|