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...
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.

     

Bennadeau's avatar
Bennadeau
Iron Contributor
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.

 

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

    Bennadeau Thank you! That worked perfectly!

Resources