SOLVED

CSV DB for web search

%3CLINGO-SUB%20id%3D%22lingo-sub-1918355%22%20slang%3D%22en-US%22%3ECSV%20DB%20for%20web%20search%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1918355%22%20slang%3D%22en-US%22%3E%3CP%3EI%20can%E2%80%99t%20figure%20out%20how%20to%20bulk%20add%20this%20URL%20in%2C%20I%20need%20the%20placeholders%20to%20be%20replaced%20with%20the%20data%20from%20the%20corresponding%20cells.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CFONT%20color%3D%22%23000000%22%3E%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fhartbroscore.com%2Fsearch%3Ftype%3Darticle%252Cpage%252Cproduct%26amp%3Bq%3D%255bYEAR%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noreferrer%22%3Ehttps%3A%2F%2Fhartbroscore.com%2Fsearch%3Ftype%3Darticle%252Cpage%252Cproduct%26amp%3Bq%3D%3CFONT%20color%3D%22%23FF0000%22%3E%5BYEAR%3C%2FFONT%3E%3C%2FA%3E%3C%2FFONT%3E%3CFONT%20color%3D%22%23FF0000%22%3E-Row%3F_%20Column-A%5D%3C%2FFONT%3E*%2B%3CFONT%20color%3D%22%23FF0000%22%3E%5BMAKE-Row-%3F_Column-B%5D%3C%2FFONT%3E*%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1918355%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1918498%22%20slang%3D%22en-US%22%3ERe%3A%20CSV%20DB%20for%20web%20search%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1918498%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F876351%22%20target%3D%22_blank%22%3E%40hartbros600%3C%2FA%3E%2C%3C%2FP%3E%3CP%3ETry%20this%20in%20cell%20D1%3C%2FP%3E%3CPRE%20class%3D%22lia-code-sample%20language-applescript%22%3E%3CCODE%3E%3DHYPERLINK(CONCATENATE(%22%20https%3A%2F%2Fhartbroscore.com%2Fsearch%3Ftype%3Darticle%252Cpage%252Cproduct%26amp%3Bq%3D%22%2CA1%2C%22*%2B%22%2CB1))%3C%2FCODE%3E%3C%2FPRE%3E%3CP%3EThen%20drag%20it%20down%20to%20fill%20the%20remaining.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

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]*

 

 

 

 

 

3 Replies
best response confirmed by hartbros600 (New Contributor)
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.

 

@Bennadeau Thank you! That worked perfectly!

@hartbros600 

 

Glad I could help