| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Trim content of a column
I have a worksheet that contains multiple columns. The first Column has a
file path. I would like to trim the path to only display the file name. For example: A 1 C:/test/folder/File1 2 C:/test/folder/File2 3 C:/test/folder/File3 4 C:/test/folder/File4 5 C:/test/folder/File5 Would like to display: A 1 File1 2 File2 3 File3 4 File4 5 File5 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Trim varying decimals from column of numbers | Excel Worksheet Functions | |||
| How to transpose formulas from column content to row content. | Excel Worksheet Functions | |||
| How to apply the trim function to a whole column. | Excel Programming | |||
| VBA Trim and Application.worksheetfunction.Trim | Excel Programming | |||
| AUTOMATICALLY CHOOSE COLUMN H OR G DEPENDANT ON CONTENT IN COLUMN. | Excel Programming | |||
Threaded Mode
