Replacing a value within a string using a formula
 

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/

Replacing a value within a string using a formula
 

Hi

Use SUBSTITUTE()


--
(When sending e-mail, use address )
Arvi Laanemets


"solo_razor" wrote in message
...
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/

Replacing a value within a string using a formula
 

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/