Nov 20 2020 07:59 AM - edited Nov 20 2020 10:20 AM
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]*
Nov 20 2020 08:39 AM
SolutionHi @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.
Nov 20 2020 08:39 AM
SolutionHi @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.