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

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

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 -