User ID

  • Thread starter Thread starter danpt
  • Start date Start date
D

danpt

Is there a formula that will return the userprofile name even if the book is
in a drive other than C:?
 
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("\",B1,FIND("\",B1,FIND("\",B1,1)+1)+1)-FIND("\",B1,FIND("\",B1,1)+1)-1)

Please let me know, if this what you wanted.
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Windows 10 How to create individual shortcut for each user 1
Trying to add environmentvariable to path: howto? 15
Look up across multiple sheets 1
Search two columns in list for first and last name and return Id 4
Open Lotus Notes with Excel Macro 3
help with if & order ..?? 1
Environment Variables: Short vs Long Pathnames? - "DOCUME~1" vs."Documents and Settings" 3
Summing like data (2) 2

Back
Top