Similar to Hyperlink?

[Mr Denove]

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

 

[Sufiyan97]

type Ctrl+K in a cell where you trying to give link
Paste sharepoint folder path