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 fun
;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(&
t;,"*",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,"\
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
I have this macro to extract tables from all the files in a particular
directory. However, this file takes only one table from a particular
file and only the first and the last column of the table.
I would request the power users to help in :
1) extracting all the tables in a particular file
2) Th
