Steps to Create a WhatsApp Link in Excel

-

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.


Comments

Post a Comment

Popular posts from this blog

Creating WhatsApp Links with Microsoft Excel

-
Creating WhatsApp Links with Microsoft Excel WhatsApp has become one of the easiest ways to connect with friends, clients, or business contacts. But did you know you can generate WhatsApp chat links directly from Microsoft Excel ? This simple trick saves time when you have a list of phone numbers and want to quickly create ready-to-use links. 🔹 What is a WhatsApp Link? A WhatsApp link lets someone start a chat with you without saving your number. The format is: https://wa.me/<PhoneNumber> For example: https://wa.me/2348132627521 When clicked, it opens WhatsApp and starts a conversation. 🔹 Why Use Excel? If you have many contacts (say, for a business campaign or class reminders), typing links one by one is time-consuming. With Excel, you can create all links automatically in seconds. 🔹 Step-by-Step Guide Open Excel and enter your phone numbers in Column A (without spaces or special characters). Example: A1 → 2348132627521 A2 → 2347012345678 In Column B...
Read more

How I Get 6.5GB of Data on Airtel for Just N1000 — My Little Hack!

-
Image
How I Get 6.5GB of Data on Airtel for Just N1000 — My Little Hack! If you're like me, you're constantly juggling between staying online and not breaking the bank. And let’s be honest — mobile data in Nigeria can vanish faster than jollof rice at a wedding.  So imagine my excitement when I discovered a legit way to get 6.5GB of data on Airtel with just N1000 ! No tricks, no shady apps — just a smart, little-known offer hiding in plain sight. Let me walk you through exactly how I did it . How to Get the 6.5GB for N1000 on Airtel Here’s a step-by-step guide to grab this offer yourself: Step 1: Open Airtel SmartCash Account Download SmarCash app on Google Play or Apple Store Sign up with your Airtel line. Step 2: Recharge Your Account Fund your account Step 3: Dial the code Dial *939*77# Select option 5 to activate Step 4: Activate the Plan Once you have the enough fund,  you’ll get an SMS confirming your 6.5GB data balance. And boom! You’re ready to scroll, stream...
Read more

HDD vs SSD: Which Storage Drive Should You Choose?

-
Image
  In the fast-paced tech world of 2025, choosing between a Hard Disk Drive (HDD) and a Solid State Drive (SSD) can make or break your computing experience. HDDs are traditional mechanical drives with spinning platters and read/write heads, while SSDs use flash memory chips with no moving parts. The core difference? HDDs rely on physical movement, making them slower but cheaper for bulk storage, whereas SSDs deliver lightning-fast electronic access. Let's break down the key differences: Speed and Performance : SSDs crush HDDs here. Boot times, app loading, and file transfers are up to 10x faster on SSDs due to no mechanical delays. For gaming or video editing, SSDs reduce load times dramatically—think seconds vs. minutes. NVMe SSDs push speeds even further, ideal for AI tasks or 8K editing. Durability and Reliability : SSDs win with no moving parts, resisting shocks and vibrations—perfect for laptops. HDDs are prone to failure from drops or wear, though modern ones are more reli...
Read more