extracting string from value in cell

S

solo_razor

hello,

I want to extract a text from text within a cell.
example:

cel a1 contains c:\windows\desktop\new\testing.xls
cel a2 contains this formula:
=MID(a1,FIND("*",SUBSTITUTE(a1,"\","*",LEN(a1)-LEN(SUBSTITUTE(a1,"\",""))))+1,LEN(a1))
Cel a2 has now as value : testing.xls

in cell a3 i want to get the c:\windows\desktop\new\ text


Can anybody help

regards,

Niek
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Check for values in column A and if found then column B must have value. 3
Replacing a value within a string using a formula 2
Extract Text in braquet and list of terms from 2 Docs 3
Help needed! Extracting Heading 3 and Contents from a Word Doc to Excel 0
How to add different text to one cell? 2
Extract Month and year from Cell containing date, month, year & time 2
Need to find a static value in a cell and then subtract from adjacent cell 1
Bold items within text string 7

Top