Hi,
Cell A1's value is "c:\windows\desktop\new\testing.xls"
This formula in B1
=MID(A1,1,SEARCH(MID(A1,FIND("*",SUBSTITUTE(A1,"\" ,"*",LEN(A1)-LEN(SUBSTITUT
E(A1,"\",""))))+1,LEN(A1)),A1)-1)
This formula in C1
=SUBSTITUTE(B1,"\new\","\old\")
--
Regards
Haldun Alay
To e-mail me, please remove AT and DOT from my e-mail address.
"solo_razor" , iletide şunu yazdı
...
Hello,
The following has happened, I created a formula
=MID(E90,FIND("*",SUBSTITUTE(E90,"\","*",LEN(E90)-LEN(SUBSTITUTE(E90,"\","")
)))+1,LEN(E90))
It has the following function: cell 90 has a value
c:\windows\desktop\new\testing.xls
The formula gives back as a result in the cel where it is placed
:testing.xls
Now i want to use a formula that first get rid of testing.xls so you
that you have as value c:\windows\desktop\new\; then another formula
must substituse \new\ with \old\ so that the value in the cel wil be
c:\windows\desktop\old\
Does anybody knows how i can make this possible
Regards,
Niek
------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/