| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
extracting string from value in cell
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 ------------------------------------------------ ~~ Message posted from http://www.ExcelTip.com/ ~~ View and post usenet messages directly from http://www.ExcelForum.com/ |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
extracting string from value in cell
In A3 enter this
= LEFT(A1,LEN(A1)-LEN(A2)) Chrissy. solo_razor wrote 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 ------------------------------------------------ ~~ 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 | |||
| Extracting elements of a string cell | Excel Worksheet Functions | |||
| Extracting Data from a string of text in a cell | Excel Worksheet Functions | |||
| Extracting text from a string | Excel Worksheet Functions | |||
| Extracting a string | Excel Discussion (Misc queries) | |||
| Extracting from a text string | Excel Worksheet Functions | |||
![solo_razor[_18_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
