Hello everyone

I need to send bulk Whatsapp messages from excel list.
this (https://www.shibaram.com/blog/how-to...-to-a-contact/) solution is great for me but i have few questions:

1. When i save it as an Excel file, the link isn't clickable. what do i need to change for that?
2. the most important thing: how can i change the formula that instead of entering phone number with country code, the country code will included automatically inside? (e.g "052-8201321" instead of "972528201321")


Thanks so much :-)