Your description is not completely clear to me. Are you looking to put just
the filename in a cell by itself? If so, just this formula and copy it down
as needed...

=TRIM(RIGHT(SUBSTITUTE(A1,"\",REPT(" ",999)),999))

--
Rick (MVP - Excel)


"JenIT" wrote in message
...
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???