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 Wisdom
Using a mouse in Excel is the work equivalent of wearing a lanyard when you first get to college

alidurfani

Board Regular
Joined
Apr 12, 2019
Messages
102
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,789
Messages
5,574,303
Members
412,586
Latest member
Medhum
Top