Steps to Create a WhatsApp Link in Excel

WhatsApp provides a simple link format:

https://wa.me/<phone-number>/?text=<your-message>

• <phone-number> must be in international format (no +, no spaces, no dashes).

  • Example: 2348012345678 (for Nigeria).

• <your-message> can be plain text. Use %20 for spaces.

• Example: Hello%20I%20am%20interested.

---

Method 1: Manually Create a Hyperlink

1. Select a cell (e.g., A1).

2. Press Ctrl + K (or right-click → Insert Hyperlink).

3. In the Address box, type:

   https://wa.me/2348012345678/?text=Hello
   

4. Click OK.

Now, when you click the cell, WhatsApp (app or web) will open a chat with that number.

---

Method 2: Use a Formula (Dynamic WhatsApp Links)

If you have phone numbers in column A, you can generate links in column B.

Example:

A (Phone)	B (WhatsApp Link)
2348012345678	=HYPERLINK("https://wa.me/"&A2&"?text=Hello%20there","Chat Now")

Formula in B2: =HYPERLINK("https://wa.me/"&A2&"?text=Hello%20there","Chat Now")

• "Chat Now" is the clickable text.

• You can replace "Hello%20there" with any custom message.

Result 👉 Clicking “Chat Now” opens WhatsApp chat directly.

---

Method 3: Add Custom Messages Dynamically

If column A has phone numbers and column B has custom messages, you can combine them.

Formula in C2:

=HYPERLINK("https://wa.me/"&A2&"?text="&SUBSTITUTE(B2," ","%20"),"Send Message")

• A2 = phone number

• B2 = custom message (e.g., Good morning, I need info)

• SUBSTITUTE replaces spaces with %20 (so the link works).

---

Example in Action

• Phone (A2): 2348012345678

• Message (B2): Hello, I am interested in your product

• Formula (C2):

  =HYPERLINK("https://wa.me/"&A2&"?text="&SUBSTITUTE(B2," ","%20"),"Send WhatsApp")
  

Result: Cell C2 shows Send WhatsApp. Clicking it opens a WhatsApp chat with the pre-filled message.

---

Pro Tip: If you’ll be sharing the Excel file, make sure your audience has WhatsApp installed (either mobile or WhatsApp Web) for the links to work.

---