Tuesday, January 3, 2023

Get file path and set hyperlink funtion in Excel

 =CONCATENATE("file://",LEFT(CELL("filename",F2),FIND("[",CELL("filename",F2))-1),F2)

=HYPERLINK($G$2,F2)

at
Labels:

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

Restrict Access to PHPMyAdmin with DirectAdmin

cd /usr/local/directadmin/ ./directadmin set one_click_pma_login 1 restart cd custombuild ./build update ./build set phpmyadmin_public no ./...