User ID
Is there a formula that will return the userprofile name even if the book is
in a drive other than C:? |
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:? |
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:? |
All times are GMT +1. The time now is 09:25 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com