How do you add an Arrayformula in column header in google sheet and adding predefined text to popula-CodePudding

This is my formula =ARRAYFORMULA(CONCAT("https://www.google.com/search?q=",J2:J)) Problem is I do not want this one below to appear in row 1 of J1 https://www.google.com/search?q= I want this --> https://www.google.com/search?q= <---- to start in J2 I do not know how to do it. Please help or advise. Thank you in advance.

CodePudding user response：

Try

=ARRAYFORMULA({"Some_title"; CONCAT("https://www.google.com/search?q=",J2:J)})

or if you want J1 to be empty

=ARRAYFORMULA({""; CONCAT("https://www.google.com/search?q=",J2:J)})