Similar to Hyperlink?

Mr Denove

Active Member
Joined
Jun 8, 2007
Messages
427
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
 

Some videos you may like

Excel Facts

Excel Joke
Why can't spreadsheets drive cars? They crash too often!

alidurfani

Board Regular
Joined
Apr 12, 2019
Messages
99
Office Version
  1. 2016
Platform
  1. Windows
type Ctrl+K in a cell where you trying to give link
Paste sharepoint folder path
 
Solution

Watch MrExcel Video

Forum statistics

Threads
1,118,278
Messages
5,571,282
Members
412,374
Latest member
Nagelgal
Top