extracting string from value in cell
 

hello,

I want to extract a text from text within a cell.
example:

cel a1 contains c:\windows\desktop\new\testing.xls
cel a2 contains this formula:
=MID(a1,FIND("*",SUBSTITUTE(a1,"\","*",LEN(a1)-LEN(SUBSTITUTE(a1,"\",""))))+1,LEN(a1))
Cel a2 has now as value : testing.xls

in cell a3 i want to get the c:\windows\desktop\new\ text


Can anybody help

regards,

Niek



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/

extracting string from value in cell
 

In A3 enter this

= LEFT(A1,LEN(A1)-LEN(A2))

Chrissy.


solo_razor wrote
hello,

I want to extract a text from text within a cell.
example:

cel a1 contains c:\windows\desktop\new\testing.xls
cel a2 contains this formula:
=MID(a1,FIND("*",SUBSTITUTE(a1,"\","*",LEN(a1)-LEN(SUBSTITUTE(a1,"\",""))))+1,LEN(a1))
Cel a2 has now as value : testing.xls

in cell a3 i want to get the c:\windows\desktop\new\ text


Can anybody help

regards,

Niek



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/