How To create WhatsApp link in MS Excel || WhatsApp Direct Link || By Hari Sir
Microsoft Excel Use Formula Function
- HyperLink Formula
- Trim Formula
- Encodeurl Formula
- Concatenate Formula
Step 1 :-
Connect The Internet In your Computer. After That Install The Whatsapp Application Software. and Start The whatsapp in Your Computer.
Step 2 :-
Start The Excel in your Computer. Microsoft Excel and Google Sheet Both are Support.
How to Start Excel.
Press The 🪟(window Key) + R = Start The Run Box------> Type The (Excel) On The Box and Click On Ok Button.
Step 3 :-
Go To the Postcron Web Site. Create The Whatsapp Link.
Step 4 :-
Create The Excel sheet.
Name | Mobile | Country Code | Job | Proposcel | Message | Whatsapp Link |
---|---|---|---|---|---|---|
Hari Sir | 8156032875 | 91 | MD | Party Invition | Message Type Hare | Formula Below In ⬇️ |
Step 5 :-
Set The Formula.
=hpyerlink(concatenate("https://api.whatsapp.com/send?phone=",trim(select country code cell),trim(select mobile cell),"&text=Hello",encodeurl(select message cell)))
This Formula is create The whatsapp link. after click on this link.
Step 6 :-
File Link: Whatsapp link
#harisir #whatsapp #whatsappdirectlink #excel #ms-excel #eece #experteducation
0 Comments