Monday, 9 January 2017

Dynamically specifying source location for Hyperlink in excel


TO FIND LOCATION OF EXCEL FILE :

=MID(CELL("filename"),1,FIND("[",CELL("filename"))-1)

CONCATENATING FILE LOCATION AND FILE NAME:

=HYPERLINK(P10&"index.html")
-

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

Git

1 git add ↳ It lets you add changes from the working directory into the staging area 2 git commit ↳ It lets you save a snapshot of currently...