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)

Headers Security Advanced & HSTS WP setup manually

Open the file for editing and paste the following snippet inside the  .htaccess file: <IfModule mod_headers.c> Header always set S...

  • Remove Autodesk software from Mac
      Uninstall products using the Remove utility For some products, you can run the Remove  ProductName  utility in the Finder > Go > App...
  • install PowerMTA on the server
    We can install PowerMTA on the server. rpm -ivh /home/PowerMTA-4.0r6.x86_64.rpm You will see the output like this Preparing... #############...
  • PowerMTA Multiple Virtual PMTA config file
    # $Id: config 2015-03-24 16:00:00 Jack $ # Sample PowerMTA configuration file # PowerMTA Multiple Virtual PMTA config file sample # # E-mai...