Replacing a value within a string using a formula

  • Thread starter Thread starter solo_razor
  • Start date Start date
S

solo_razor

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
 
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.
 
Back
Top