Adjusting URL column formula

Copper Contributor

Greetings,

 

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-  https://bobsmadeupsite.org/4321     

D2- 4345  E2-  https://bobsmadeupsite.org/4345      

D3- 4598  E3- https://bobsmadeupsite.org/4598

 

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

 

Help would be appreciated.  Thanks.

3 Replies

@Cosand1962 

In E1

=HYPERLINK("https://bobsmadeupsite.org/" & D1 )

etc.

Thanks.

@Cosand1962 , you are welcome