Very clever solution, thank you! Would never have thought of doing it this way. Now to figure out how to add in a country code of 1 if it's not present...
If you have a list of countries with their corresponding codes, you can look it up and concatenate. You need to have a column with countries in your data set. Also, how do you know if the country code is there or not? What is the logic?
Excellent video! This formula worked like a charm for me, thank you.
This is amazing and saved my butt at work! Thank you for sharing!
Fantastic!
Very clever solution, thank you! Would never have thought of doing it this way. Now to figure out how to add in a country code of 1 if it's not present...
If you have a list of countries with their corresponding codes, you can look it up and concatenate. You need to have a column with countries in your data set. Also, how do you know if the country code is there or not? What is the logic?