Thread
:
Replacing a value within a string using a formula
View Single Post
#
2
Posted to microsoft.public.excel.programming
Arvi Laanemets
external usenet poster
Posts: 510
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/
Reply With Quote
Arvi Laanemets
View Public Profile
Find all posts by Arvi Laanemets