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

  • Thread starter Thread starter JenIT
  • Start date Start date
J

JenIT

I have an export file that is a list of file names
Some times the name is 3 deep sometimes more:
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???
 
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))
 
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.
 
Back
Top