Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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/ |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Replacing a formula with the actual string or number | Excel Discussion (Misc queries) | |||
Extracting and replacing the first word in a String of text | Excel Worksheet Functions | |||
Replacing numeric X-axis labels with corresponding text string | Excel Discussion (Misc queries) | |||
Replacing a random string of 5 numbers | Excel Discussion (Misc queries) | |||
Create a formula into a String then assign string to a cell | Excel Programming |