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,...

I am facing this issue even when there is no issues in my data when i look over in the columns section. can anyone help me out.

in the above image i am unable to proceed with complete data only numbers are visible not numerical or symbols i.e A/101, A/25UP, etc

i want to know that how can my co admins get a username and password to login also i want to get notified if they are making any changes.