Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Extract Name from File Path
Hi all, in cell A1 i have file path as below
C:\Documents and Settings\My Documents\Tests\Test1\Simon Brown.txt and i got macro on a button (see below) Sub Button1_Click() cv = Range("a1").Value Range("a3").Value = Right(cv, Len(cv) - InStrRev(cv, "\")) End Sub I get result "Simon Brown.txt" in cell A3 but i just need result "Simon Brown". So please can anyone help that what changes i should do in my macro above which should get rid of any thing after dot like .txt and just give the person name like "Simon Brown" |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to extract only file name from folder path string in Excel? | Excel Worksheet Functions | |||
extract path from FullName | Excel Programming | |||
How to extract data from File Path | Excel Programming | |||
Formula too long - new file path is shorter than old file path - Excel 2003 | Excel Worksheet Functions | |||
Extract Path From String | Excel Programming |