Adjusting URL column formula

Copper Contributor



In column D, I have a specific page number for websites.


I am trying to create a column E, which would have a clickable link for each page.


For example:   

D1- 4321  E1-     

D2- 4345  E2-      

D3- 4598  E3-


Is there a simple formula to alter column E to add and adjust column D's information?


Help would be appreciated.  Thanks.

3 Replies


In E1

=HYPERLINK("" & D1 )



@Cosand1962 , you are welcome