Resolve Dynamic Hyperlink in Google Sheets & Excel

Fix Dynamic Hyperlink with Pre-Filled Text in Google Sheets & Excel
Hello,

I need help fixing a dynamic hyperlink issue in Google Sheets and Excel.

I have a system where:

- Column B = Phone Number
- Column S = Generated text (using formulas)
- Column G = Hyperlink button

---

Current setup:

A hyperlink is created using a URL with a phone number and text parameter.

---

Issue:

- Link opens correctly
- But text is not passed properly
- Sometimes only partial or incorrect value appears

---

Details:

- Text is dynamic (formula-based using multiple cells)
- Includes:
- Multiline text
- Special characters
- Emojis
- Personalized values

- Issue happens in both:
- Google Sheets
- Excel

---

Requirement:

- Fix hyperlink so full text passes correctly
- Proper handling of multiline text and special characters
- Compatible solution for both Excel and Google Sheets

---

Goal:

Click hyperlink → Opens with correctly pre-filled text

---

Budget: ₹500 – ₹1500