User ID
Hi, Satti,
No, that is not what I meant. The formula in cell B1 is for a Book in C:
drive.
I need one that is in drive other than C:
Thanks for your help.
"Satti Charvak" wrote:
Hi Dan,
Ive used 2 cells to make a formula, you can inegrate them also, bu that
would make a big formula.
in cell B1, i have put:
=CELL("filename",A1)
and in cell c1, i have put:
=MID(B1,FIND("\",B1,FIND("\",B1,1)+1)+1,FIND("\",B 1,FIND("\",B1,FIND("\",B1,1)+1)+1)-FIND("\",B1,FIND("\",B1,1)+1)-1)
Please let me know, if this what you wanted.
--
Kind Regards,
Satti Charvak
Only an Excel Enthusiast
Noida, India
"danpt" wrote:
Is there a formula that will return the userprofile name even if the book is
in a drive other than C:?
|