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 Select a cell (e.g., A1). Press Ctrl + K (or right-click → Insert Hyperlink ). In the Address box, type: https://wa.me/2348012345678/?text=Hello 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...