CSV DB for web search

[hartbros600]

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=[YEAR-Row?_ Column-A]*+[MAKE-Row-?_Column-B]*

[#2 · Accepted solution]

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]

@Bennadeau Thank you! That worked perfectly!

[#4]

@hartbros600 

Glad I could help