Good day Experts,
I'm working on a project now where I create many Excel spreadsheets from database exports. One of the columns in the data that I get from the database is a UNC path, for example: \\servername\share name\folder 1\folder 2\.
I'm sending these Excel sheets to users. Is there any way that I can easily convert the UNC path column in Excel so that all the fields (with UNC paths) in this column are hyperlinks that point to the UNC path in the field value?