Hi setiyowati,
Thanks for the effort. This helps . I needed a formula to extract only
the folder name, while your formula extracts the whole path. I used
another formula available in the net to extract file name in another
cell. ie., =MID(A25,FIND("*",SUBSTITUTE(A25,"\","*",LEN(A25)-
LEN(SUBSTITUTE(A25,"\",""))))+1,LEN(A25))
regards,
On May 28, 6:59 am, "STDEV(i)" <setiyowati.d...@gmail.com> wrote:
> try this formula
> =*SUBSTITUTE(B3*
> ,MID(B3,1+FIND("^",SUBSTITUTE(B3,"\","^",LEN(B3)-LEN(SUBSTITUTE(B3,"\",""))))-1,999),"")
>
> and see the attachment if it helps
>
> On Fri, May 27, 2011 at 12:56 PM, Jhoomla <amith.yeshwa...@gmail.com> wrote:
> > Does any one have a function or formula to extract for a path for
> > eg.,
>
> > E:\02 My Documents\20 Ebooks and Articles\10.04 Tintin\01 Tintin in
> > the Land of the Soviets.pdf
>
> > Parent Folder: = 10.04 Tintin
> > Parent.Parent.folder = 20 Ebooks and Articles
> > Parent.Parent.Parent.Folder= 02 My Documents
>
> > any help in this regard would be greatly appreciated.
>
>
>
> ctv_File Path and his parents.xls
> 20KViewDownload
--
----------------------------------------------------------------------------------
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel
