Thread: How to extract data from File Path
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Ron de Bruin Ron de Bruin is offline
external usenet poster
  
Posts: 11,123
Default How to extract data from File Path
Hi DK

Why not use DataText to columns in the menubar

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


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

Reply With QuoteReply With Quote