RE: $$Excel-Macros$$ Formula to extract parent folder, parent of parent folder etc
Assuming path is in A1 :
Folder :
=MID(A1,LARGE((MID(A1,ROW(INDIRECT("1:"&LEN(A1))),1)="\")*ROW(INDIRECT("1:"&
LEN(A1))),2)+1,MAX((MID(A1,ROW(INDIRECT("1:"&LEN(A1))),1)="\")*ROW(INDIRECT(
"1:"&LEN(A1-LARGE((MID(A1,ROW(INDIRECT("1:"&LEN(A1))),1)="\")*ROW(INDIRE
CT("1:"&LEN(A1))),2)-1)
Parent folder :
=MID(A1,LARGE((MID(A1,ROW(INDIRECT("1:"&LEN(A1))),1)="\")*ROW(INDIRECT("1:"&
LEN(A1))),3)+1,LARGE((MID(A1,ROW(INDIRECT("1:"&LEN(A1))),1)="\")*ROW(INDIREC
T("1:"&LEN(A1))),2)-1)
Parent parent folder :
=MID(A1,LARGE((MID(A1,ROW(INDIRECT("1:"&LEN(A1))),1)="\")*ROW(INDIRECT("1:"&
LEN(A1))),4)+1,LARGE((MID(A1,ROW(INDIRECT("1:"&LEN(A1))),1)="\")*ROW(INDIREC
T("1:"&LEN(A1))),3)-1)
Daniel
-Message d'origine-
De : excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] De
la part de Jhoomla
Envoyé : vendredi 27 mai 2011 07:57
À : MS EXCEL AND VBA MACROS
Objet : $$Excel-Macros$$ Formula to extract parent folder, parent of parent
folder etc
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.
--
--
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
--
--
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
RE: $$Excel-Macros$$ Formula to extract parent folder, parent of parent folder etc
Better :
Parent folder :
=MID(A1,LARGE((MID(A1,ROW(INDIRECT("1:"&LEN(A1))),1)="\")*ROW(INDIRECT("1:"&
LEN(A1))),3)+1,LARGE((MID(A1,ROW(INDIRECT("1:"&LEN(A1))),1)="\")*ROW(INDIREC
T("1:"&LEN(A1))),2)-LARGE((MID(A1,ROW(INDIRECT("1:"&LEN(A1))),1)="\")*ROW(IN
DIRECT("1:"&LEN(A1))),3)-1)
Parent parent folder :
=MID(A1,LARGE((MID(A1,ROW(INDIRECT("1:"&LEN(A1))),1)="\")*ROW(INDIRECT("1:"&
LEN(A1))),4)+1,LARGE((MID(A1,ROW(INDIRECT("1:"&LEN(A1))),1)="\")*ROW(INDIREC
T("1:"&LEN(A1))),3)-LARGE((MID(A1,ROW(INDIRECT("1:"&LEN(A1))),1)="\")*ROW(IN
DIRECT("1:"&LEN(A1))),4)-1)
Daniel
-Message d'origine-
De : excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] De
la part de Jhoomla
Envoyé : vendredi 27 mai 2011 07:57
À : MS EXCEL AND VBA MACROS
Objet : $$Excel-Macros$$ Formula to extract parent folder, parent of parent
folder etc
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.
--
--
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
--
--
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
Re: $$Excel-Macros$$ Formula to extract parent folder, parent of parent folder etc
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 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.
--
--
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
ctv_File Path and his parents.xls
Description: MS-Excel spreadsheet
Re: $$Excel-Macros$$ Formula to extract parent folder, parent of parent folder etc
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)" 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 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
Re: $$Excel-Macros$$ Formula to extract parent folder, parent of parent folder etc
Hi Daniel
Thank you for the effort. When I use the formula, I am getting #NUM!
error. I am not able to understand what is wrong.
Would you be able to attach an excel file which is working. I am using
excel 2007.
regards,
On May 27, 5:46 pm, "Daniel" wrote:
> Assuming path is in A1 :
> Folder :
> =MID(A1,LARGE((MID(A1,ROW(INDIRECT("1:"&LEN(A1))),1)="\")*ROW(INDIRECT("1:"&
> LEN(A1))),2)+1,MAX((MID(A1,ROW(INDIRECT("1:"&LEN(A1))),1)="\")*ROW(INDIRECT(
> "1:"&LEN(A1-LARGE((MID(A1,ROW(INDIRECT("1:"&LEN(A1))),1)="\")*ROW(INDIRE
> CT("1:"&LEN(A1))),2)-1)
> Parent folder :
> =MID(A1,LARGE((MID(A1,ROW(INDIRECT("1:"&LEN(A1))),1)="\")*ROW(INDIRECT("1:"&
> LEN(A1))),3)+1,LARGE((MID(A1,ROW(INDIRECT("1:"&LEN(A1))),1)="\")*ROW(INDIREC
> T("1:"&LEN(A1))),2)-1)
> Parent parent folder :
> =MID(A1,LARGE((MID(A1,ROW(INDIRECT("1:"&LEN(A1))),1)="\")*ROW(INDIRECT("1:"&
> LEN(A1))),4)+1,LARGE((MID(A1,ROW(INDIRECT("1:"&LEN(A1))),1)="\")*ROW(INDIREC
> T("1:"&LEN(A1))),3)-1)
>
> Daniel
>
> -Message d'origine-
> De : excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] De
> la part de Jhoomla
> Envoyé : vendredi 27 mai 2011 07:57
> À : MS EXCEL AND VBA MACROS
> Objet : $$Excel-Macros$$ Formula to extract parent folder, parent of parent
> folder etc
>
> 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.
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links
> :http://twitter.com/exceldailytip2. Join our LinkedIN group
> @http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials athttp://www.excel-macros.blogspot.com
> 4. Learn VBA Macros athttp://www.quickvba.blogspot.com5. Excel Tips and
> Tricks athttp://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below
> linkhttp://www.facebook.com/discussexcel
--
--
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
RE: $$Excel-Macros$$ Formula to extract parent folder, parent of parent folder etc
Sorry, I should have said that these are array formulas (validate with
Ctrl+Shift+Enter). Have a look at the attached file.
Regards.
Daniel
-Message d'origine-
De : excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] De
la part de Jhoomla
Envoyé : lundi 30 mai 2011 06:46
À : MS EXCEL AND VBA MACROS
Objet : Re: $$Excel-Macros$$ Formula to extract parent folder, parent of
parent folder etc
Hi Daniel
Thank you for the effort. When I use the formula, I am getting #NUM!
error. I am not able to understand what is wrong.
Would you be able to attach an excel file which is working. I am using excel
2007.
regards,
On May 27, 5:46 pm, "Daniel" wrote:
> Assuming path is in A1 :
> Folder :
> =MID(A1,LARGE((MID(A1,ROW(INDIRECT("1:"&LEN(A1))),1)="\")*ROW(INDIRECT
> ("1:"&
> LEN(A1))),2)+1,MAX((MID(A1,ROW(INDIRECT("1:"&LEN(A1))),1)="\")*ROW(IND
> IRECT(
> "1:"&LEN(A1-LARGE((MID(A1,ROW(INDIRECT("1:"&LEN(A1))),1)="\")*ROW(
> INDIRE
> CT("1:"&LEN(A1))),2)-1)
> Parent folder :
> =MID(A1,LARGE((MID(A1,ROW(INDIRECT("1:"&LEN(A1))),1)="\")*ROW(INDIRECT
> ("1:"&
> LEN(A1))),3)+1,LARGE((MID(A1,ROW(INDIRECT("1:"&LEN(A1))),1)="\")*ROW(I
> NDIREC
> T("1:"&LEN(A1))),2)-1)
> Parent parent folder :
> =MID(A1,LARGE((MID(A1,ROW(INDIRECT("1:"&LEN(A1))),1)="\")*ROW(INDIRECT
> ("1:"&
> LEN(A1))),4)+1,LARGE((MID(A1,ROW(INDIRECT("1:"&LEN(A1))),1)="\")*ROW(I
> NDIREC
> T("1:"&LEN(A1))),3)-1)
>
> Daniel
>
> -Message d'origine-
> De : excel-macros@googlegroups.com
> [mailto:excel-macros@googlegroups.com] De la part de Jhoomla Envoyé :
> vendredi 27 mai 2011 07:57 À : MS EXCEL AND VBA MACROS Objet :
> $$Excel-Macros$$ Formula to extract parent folder, parent of parent
> folder etc
>
> 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.
>
> --
> --
> --
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links
> :http://twitter.com/exceldailytip2. Join our LinkedIN group
> @http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials athttp://www.excel-macros.blogspot.com
> 4. Learn VBA Macros athttp://www.quickvba.blogspot.com5. Excel Tips
> and Tricks athttp://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below
> linkhttp://www.facebook.com/discussexcel
--
--
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
--
--
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
ExtractFolders.xls
Description: MS-Excel spreadsheet
Re: $$Excel-Macros$$ Formula to extract parent folder, parent of parent folder etc
Hi Amith, See the attached file. Let me know in case of any queries. Best Regards, DILIPandey On 5/27/11, Jhoomla 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. > > -- > -- > 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 > -- Thanks & Regards, DILIP KUMAR PANDEY, mvp MBA,B.Com(Hons),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 62, India -- -- 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 Parent Folders by DILIPandey.xls Description: MS-Excel spreadsheet
RE: $$Excel-Macros$$ Formula to extract parent folder, parent of parent folder etc
Hi
See if it Help
Sub Extract()
Range("A1").Copy Range("A4")
Application.CutCopyMode = False
Range("A4").Select
Selection.TextToColumns Destination:=Range("A4"), DataType:=xlDelimited,
_
TextQualifier:=xlDoubleQuote, ConsecutiveDelimiter:=False,
Tab:=True, _
Semicolon:=False, Comma:=False, Space:=False, Other:=True, OtherChar
_
:="\", FieldInfo:=Array(Array(1, 1), Array(2, 1), Array(3, 1),
Array(4, 1), Array(5, _
1)), TrailingMinusNumbers:=True
Range("A4").Select
Range(Selection, Selection.End(xlToRight)).Select
Selection.Copy
Range("D6").Select
Selection.PasteSpecial Paste:=xlPasteAll, Operation:=xlNone,
SkipBlanks:= _
False, Transpose:=True
Rows(4).ClearContents
End Sub
-Original Message-
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Daniel
Sent: Monday, May 30, 2011 2:47 PM
To: excel-macros@googlegroups.com
Subject: RE: $$Excel-Macros$$ Formula to extract parent folder, parent of
parent folder etc
Sorry, I should have said that these are array formulas (validate with
Ctrl+Shift+Enter). Have a look at the attached file.
Regards.
Daniel
-Message d'origine-
De : excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] De
la part de Jhoomla Envoyé : lundi 30 mai 2011 06:46 À : MS EXCEL AND VBA
MACROS Objet : Re: $$Excel-Macros$$ Formula to extract parent folder, parent
of parent folder etc
Hi Daniel
Thank you for the effort. When I use the formula, I am getting #NUM!
error. I am not able to understand what is wrong.
Would you be able to attach an excel file which is working. I am using excel
2007.
regards,
On May 27, 5:46 pm, "Daniel" wrote:
> Assuming path is in A1 :
> Folder :
> =MID(A1,LARGE((MID(A1,ROW(INDIRECT("1:"&LEN(A1))),1)="\")*ROW(INDIRECT
> ("1:"&
> LEN(A1))),2)+1,MAX((MID(A1,ROW(INDIRECT("1:"&LEN(A1))),1)="\")*ROW(IND
> IRECT(
> "1:"&LEN(A1-LARGE((MID(A1,ROW(INDIRECT("1:"&LEN(A1))),1)="\")*ROW(
> INDIRE
> CT("1:"&LEN(A1))),2)-1)
> Parent folder :
> =MID(A1,LARGE((MID(A1,ROW(INDIRECT("1:"&LEN(A1))),1)="\")*ROW(INDIRECT
> ("1:"&
> LEN(A1))),3)+1,LARGE((MID(A1,ROW(INDIRECT("1:"&LEN(A1))),1)="\")*ROW(I
> NDIREC
> T("1:"&LEN(A1))),2)-1)
> Parent parent folder :
> =MID(A1,LARGE((MID(A1,ROW(INDIRECT("1:"&LEN(A1))),1)="\")*ROW(INDIRECT
> ("1:"&
> LEN(A1))),4)+1,LARGE((MID(A1,ROW(INDIRECT("1:"&LEN(A1))),1)="\")*ROW(I
> NDIREC
> T("1:"&LEN(A1))),3)-1)
>
> Daniel
>
> -Message d'origine-
> De : excel-macros@googlegroups.com
> [mailto:excel-macros@googlegroups.com] De la part de Jhoomla Envoyé :
> vendredi 27 mai 2011 07:57 À : MS EXCEL AND VBA MACROS Objet :
> $$Excel-Macros$$ Formula to extract parent folder, parent of parent
> folder etc
>
> 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.
>
> --
> --
> --
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links
> :http://twitter.com/exceldailytip2. Join our LinkedIN group
> @http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials athttp://www.excel-macros.blogspot.com
> 4. Learn VBA Macros athttp://www.quickvba.blogspot.com5. Excel Tips
> and Tricks athttp://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below
> linkhttp://www.facebook.com/discussexcel
--
--
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
Re: $$Excel-Macros$$ Formula to extract parent folder, parent of parent folder etc
Thanks, this helps. regards, Amith On May 30, 10:05 pm, Dilip Pandey wrote: > Hi Amith, > > See the attached file. > Let me know in case of any queries. > > Best Regards, > DILIPandey > > On 5/27/11, Jhoomla 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. > > > -- > > -- > > 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 athttp://www.excel-macros.blogspot.com > > 4. Learn VBA Macros athttp://www.quickvba.blogspot.com > > 5. Excel Tips and Tricks athttp://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 > > -- > Thanks & Regards, > > DILIP KUMAR PANDEY, mvp > MBA,B.Com(Hons),BCA > Mobile: +91 9810929744 > dilipan...@gmail.com > dilipan...@yahoo.com > New Delhi - 62, India > > Parent Folders by DILIPandey.xls > 18KViewDownload -- -- 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
