creating link to WhatsApp web with phone number

%3CLINGO-SUB%20id%3D%22lingo-sub-3331695%22%20slang%3D%22en-US%22%3Ecreating%20link%20to%20WhatsApp%20web%20with%20phone%20number%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3331695%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20there%2C%3CBR%20%2F%3E%3CBR%20%2F%3EI%20have%20an%20Excel%20file%20with%20many%20phone%20numbers%20in%20this%20format%3A%20%2B1%20123-456-7890%3CBR%20%2F%3EI%20want%20to%20create%20a%20link%20to%20WhatsApp%20so%20it%20means%20that%20I%20need%20to%20add%20this%20before%3A%26nbsp%3B%3CSPAN%20class%3D%22%22%3E%3CSPAN%3E%3CA%20href%3D%22https%3A%2F%2Fwa.me%2F%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noreferrer%22%3Ehttps%3A%2F%2Fwa.me%2F%3C%2FA%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3CBR%20%2F%3EThe%20problem%20is%20that%20the%20link%20with%20space%20and%26nbsp%3B%3CSPAN%3Ehyphens%20is%3C%2FSPAN%3E%26nbsp%3Bnot%20valid%20and%20the%20browser%20doesn't%20direct%20me%20to%20the%20page.%3CBR%20%2F%3EFor%20example%2C%20WhatsApp%20doesn't%20recognize%20this%20link%3A%26nbsp%3B%3CSPAN%20class%3D%22%22%3E%3CSPAN%3E%3CA%20href%3D%22https%3A%2F%2Fwa.me%2F%2B1%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noreferrer%22%3Ehttps%3A%2F%2Fwa.me%2F%2B1%3C%2FA%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3CSPAN%3E%20123-456-7890.%3CBR%20%2F%3E%3C%2FSPAN%3EWhile%20this%20link%20is%20OK%20and%20directs%20me%20to%20the%20conversation%20on%20WhatsApp%20web%3A%26nbsp%3B%3CSPAN%20class%3D%22%22%3E%3CSPAN%3E%3CA%20href%3D%22https%3A%2F%2Fwa.me%2F%2B11234567890%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noreferrer%22%3Ehttps%3A%2F%2Fwa.me%2F%2B11234567890%3C%2FA%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3CBR%20%2F%3E%3CBR%20%2F%3EI%20wish%20to%20find%20a%20solution%20to%20build%20the%20right%20format%20and%20create%20the%20link%20for%20the%20thousands%20of%20numbers%20I%20have.%3CBR%20%2F%3EMuch%20appreciated.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3331695%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

Hi there,

I have an Excel file with many phone numbers in this format: +1 123-456-7890
I want to create a link to WhatsApp so it means that I need to add this before: https://wa.me/
The problem is that the link with space and hyphens is not valid and the browser doesn't direct me to the page.
For example, WhatsApp doesn't recognize this link: https://wa.me/+1 123-456-7890.
While this link is OK and directs me to the conversation on WhatsApp web: https://wa.me/+11234567890

I wish to find a solution to build the right format and create the link for the thousands of numbers I have.
Much appreciated.

0 Replies