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???

file names and path. How text to columns from right to left
 

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???

file names and path. How text to columns from right to left
 

I may have been unclear - but Rick you nailed it. THANKS!!! I'm
trying to sort out our files to find out where we have saved multiple
times - there have been too many hands saving forms and such.

I appreciate your help and CHEERS to all who help on this group. I
have always had such great results when posting excel questions
here.


On Nov 24, 9:52*am, "Rick Rothstein"
wrote:
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???- Hide quoted text -

- Show quoted text -