one column has url links other has the text to which I want to add these urls in google sheets.
Like for example there exists formula to combine any two columns into one column with text of both separate columns into this one column
Example. Column A has First Name and Column B has Last Name. The combining formula helps put First and Last Name in single column by combining data from Column A & B into say Column C
Similarly, I want this Column C’s to have URLs mentioned in Column, say D to be added automatically to all entries of Column C.
Lets say Column X has Company Name and Column Y has Website Links. I need a formula or shortcut that will automatically to Column X entries create hyperlinks from respective corresponding Column Y entry
Thus far, only way known is to individually copy link of each entry from one column to another and this could easily take several hours
Chalanas Strategy Management C is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
1