That would extract all the data which has \ as separator in the
columns. I just want 3rd and 4th. There is no specific length of the
text. If there had been, I would have used MID.

On Jun 13, 1:22 pm, "Ron de Bruin" wrote:
Hi DK

Why not use DataText to columns in the menubar

--

Regards Ron de Bruinhttp://www.rondebruin.nl/tips.htm



"DK" wrote in ooglegroups.com...
I have extracted a directory listing like:
I:\Account_Documents\ABC\ABCXYZ\GOV Documents

I want to extract the third directory (ABC) into one column and fourth
directory (ABCXYZ) in another column from the whole.

How can I do this quickly?- Hide quoted text -

- Show quoted text -