Hello everyone I want to know How do I concatenate two columns one of which is link and other is text but i want to make it clickable like the following expression in google sheet.
=HYPERLINK(CONCATENATE(“https:/ /api.whatsapp.com/send?phone=+91”,G4,"&text=",F4),“SEND”)
Is it possible? all ideas can help thanks.
LinkedIn
Twitter
