I'm trying to combine multiple functions into one formula in GoogleSheets spreadsheet.
I've tried learning more from Google's Help center and through YouTube but didn't came to satisfactory result.
Anyways, I have these:
A: Column with some of keywords
B: Column where I replace whitespace character with + sign: =REGEXREPLACE(A2, " ", "+")
C: Column to generate Google search query URL with previously generated data: =CONCATENATE("https://www.google.com/search?q=intitle:", """"&B2&"""" )
Is there a way for C column to take A column as a data input without need for B column to exist, in form of an oneliner formula which combines both functions?
Result should look like this: https://www.google.rs/search?q=intitle:example+keyword