Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to trim cell information
I have information in a column with a file path. I would like it to only
display the file name. Can this be done? For example: C:\test excel\PROPS\abcdefg.xls C:\test excel\PROPS\dfsdagg.xls C:\test excel\PROPS\12324vcs.xls I would like it to display only the file name without the extension or path abcdefg dfsdagg 12324vcs |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I trim cell values | Excel Discussion (Misc queries) | |||
How to trim a character from a cell ? | Excel Programming | |||
Trim down on cell references | New Users to Excel | |||
Trim cell contents | Excel Worksheet Functions | |||
VBA Trim and Application.worksheetfunction.Trim | Excel Programming |