| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
file names and path. How text to columns from right to left
I have an export file that is a list of file names
Some times the name is 3 deep sometimes mo O:\Shared\700 Club\700 Club Information.doc O:\Shared\Accounting-IT\Invoices\Pack America\Pack America - Glen Tyler.doc I am need to get these in columns so that the file names all line up. So...I need to delimited starting from the right with the \ as the deliminator. My data is in column A. I would probably start 10 columns over pasting the first data (file name) as I do not know how deep the deepest file path is. Is there a way to do this??? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| file names with full path | Excel Programming | |||
| Linked File Names and Path | Excel Programming | |||
| Pulling file names & path from folder and putting them in cells | Excel Programming | |||
| Indirect and Path & File Names | Excel Discussion (Misc queries) | |||
| Path names to xla file in formula | Excel Programming | |||
Threaded Mode
