Afternoon all,
I use a report that others populate with the file or folder path in a shared drive, they paste the address into a cell and the adjacent cell then creates the hyperlink using the simple formula =Hyperlink()
The issue is if a link from Sharepoint is pasted into the cell the hyperlink the formula doesnt create the link to the sharepoint folder.
Is there some formula that i can use to create the sharepoint folder path as a hyperlink?
Thanks in advance.
S
I use a report that others populate with the file or folder path in a shared drive, they paste the address into a cell and the adjacent cell then creates the hyperlink using the simple formula =Hyperlink()
The issue is if a link from Sharepoint is pasted into the cell the hyperlink the formula doesnt create the link to the sharepoint folder.
Is there some formula that i can use to create the sharepoint folder path as a hyperlink?
Thanks in advance.
S