Forum Discussion

hartbros600's avatar
hartbros600
Copper Contributor
Nov 20, 2020
Solved

CSV DB for web search

I can’t figure out how to bulk add this URL in, I need the placeholders to be replaced with the data from the corresponding cells.

 

 https://hartbroscore.com/search?type=article%2Cpage%2Cproduct&q=%5bYEAR-Row?_ Column-A]*+[MAKE-Row-?_Column-B]*

 

 

 

 

 

excel
Formulas and Functions
  • Bennadeau's avatar
    Bennadeau
    Nov 20, 2020

    Hi hartbros600,

    Try this in cell D1

    =HYPERLINK(CONCATENATE(" https://hartbroscore.com/search?type=article%2Cpage%2Cproduct&q=",A1,"*+",B1))

    Then drag it down to fill the remaining.

     

3 Replies

Resources