Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
User ID
Is there a formula that will return the userprofile name even if the book is
in a drive other than C:? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
User ID
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:? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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:? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2007 displays Locked by "another user", does not show User I | Excel Discussion (Misc queries) | |||
How do I format a cell, so the user must use a user calendar? | Excel Discussion (Misc queries) | |||
How do I format a cell, so the user must use a user calendar? | Excel Discussion (Misc queries) | |||
new user | New Users to Excel | |||
New User help me | Excel Worksheet Functions |