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
> >
ps.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
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.
11 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
quot;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 ma
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(SUBSTITU
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 M
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@g
ot;)*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 pare
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 hel
10 matches
Mail list logo
