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)

No comments:

Post a Comment

Linux command to find user who failed to login from pop/imap

 journalctl -u dovecot -g "auth failed" grep -i "auth failed" /var/log/mail.log | grep -E "imap|pop" journalct...