top of page

How to enter country code (66) in mobile number with Excel?


How to enter country code (66) in mobile number with Excel?  📌How to enter country code 66 in mobile number easily with Excel 1. Open a CSV or Excel file containing a list of mobile numbers for Facebook Custom Audience. 2. In Cell B, enter the Replace formula by typing =REPLACE( when typing to the opening parenthesis, Excel will display an example of instructions for specifying values ​​in the formula, each with the following meanings: - old_text is the Cell that we will edit. Here is Cell A1, click on A1 and put a comma. - start_num is to specify that the new data to be replaced must start with the number of characters. In this case, we will use 66 instead of 0, which is the first one, so for this part, type the number 1 and type a comma. - num_chars is to replace how many characters from start_num, in this case we will replace only 0, so type 1 and type the same comma. - new_text is the new data that we will use to replace the number 0. In this part, we need to enter the country code 66 as shown in the picture, type the closing parenthesis and enter to complete the process of entering the formula. 3. When entering the correct formula, you will receive a new mobile number in the B1 field with the country code. After that, it's up to the last step is to change all the remaining mobile numbers to the country code. Here, many people are familiar with dragging cells that have been covered by the formula until the last number, which can be done. But if there are a million mobile numbers like I used to have to do How to drag Why wouldn't it be? A technique that many people may not know is that double-clicking the square of the green square with the formula will copy the formula to the last cell that contains all cell phone numbers in box A. 4. After completing the third step, the results will be ready to be uploaded to Facebook. For those who made from xls file before uploading, save it as csv first because facebook doesn't accept xls file.  📌 How can I use Custom Audience in Targeting? If to give a brief summary When choosing to use Custom Audience targeting, the nature and purpose are quite specific. Most of them are mainly used for e-commerce but can be applied in other cases as well. - Used to give special privileges to existing customers only This case just takes the phone number of the person who is the real customer. then upload up Then choose as a target audience for advertising privileges to old customers. - Used to give special privileges to new customers The case is just the reverse of the first case by setting the normal Targeting first, such as Gender, Age, Interests, and then excludes the Custom Audience generated from the first case. - Used to present the product to match the behavior that has been purchased. This case is similar to the first case. Just will do Segment separately according to the category of products that have been purchased. In order to send product ads to match the behavior even more. - To create a Look a like Audience from people who are already customers Because doing a look a like from people who have bought it will result in new Audience who are more likely to buy the product as well.  What is Facebook Custom Audience? Custom Audiences create an audience for advanced ad impressions. Different from the basic audience selection such as gender, age, interests that the Facebook system provides completely. There are many ways to do Custom Audience. But the method that works well and is very accurate is to upload the mobile phone number that we have on the system of Facebook so that Facebook can map it to the Facebook ID that is tied to the mobile number. From the past experience, when doing Custom Audience in this way, the rate of mapping is quite high at 50-70%. This means that if we have a large number of target audience numbers, mapping with Facebook ID will be will only get more target groups This will allow us to send advertisements to a specific target audience individually from the mobile number we uploaded.  ------------------------------------------------------------------------------------- Interested in online marketing care services | online marketing | complete graphics | can contact us anytime | brand building | online marketing | online marketing plan | brand building | Facebook fan page care | Take care of LINE OA. You can contact us 24 hours a day.   Details of online marketing services >> https://www.chatstickmarket.com/langran Examples of various brands that we take care of online marketing >>https://www.chatstickmarket.com/portfolio ---------------------------------------------------------------------------------------  💙 Consult our team 💙 📱Tel : 0840104252 📱0947805680 Office Hotline : 034-900-165 , 02-297-0811 (Monday-Friday) 📨 Inbox : http://m.me/ChatStick.TH ┏━━━━━━━━━┓ 📲 LINE: @chatstick ┗━━━━━━━━━┛ or click https://goo.gl/KuzCpM 🎉 details at http://www.chatstickmarket.com/langran 🎉 See our work at https://www.chatstickmarket.com/portfolio

How to enter country code (66) in mobile number with Excel?


📌How to enter country code 66 in mobile number easily with Excel

1. Open a CSV or Excel file containing a list of mobile numbers for Facebook Custom Audience.

2. In Cell B, enter the Replace formula by typing =REPLACE( when typing to the opening parenthesis, Excel will display an example of instructions for specifying values ​​in the formula, each with the following meanings:

- old_text is the Cell that we will edit. Here is Cell A1, click on A1 and put a comma.

- start_num is to specify that the new data to be replaced must start with the number of characters. In this case, we will use 66 instead of 0, which is the first one, so for this part, type the number 1 and type a comma.

- num_chars is to replace how many characters from start_num, in this case we will replace only 0, so type 1 and type the same comma.

- new_text is the new data that we will use to replace the number 0. In this part, we need to enter the country code 66 as shown in the picture, type the closing parenthesis and enter to complete the process of entering the formula.

3. When entering the correct formula, you will receive a new mobile number in the B1 field with the country code. After that, it's up to the last step is to change all the remaining mobile numbers to the country code. Here, many people are familiar with dragging cells that have been covered by the formula until the last number, which can be done. But if there are a million mobile numbers like I used to have to do How to drag Why wouldn't it be? A technique that many people may not know is that double-clicking the square of the green square with the formula will copy the formula to the last cell that contains all cell phone numbers in box A.

4. After completing the third step, the results will be ready to be uploaded to Facebook. For those who made from xls file before uploading, save it as csv first because facebook doesn't accept xls file.


📌 How can I use Custom Audience in Targeting?

If to give a brief summary When choosing to use Custom Audience targeting, the nature and purpose are quite specific. Most of them are mainly used for e-commerce but can be applied in other cases as well.

- Used to give special privileges to existing customers only This case just takes the phone number of the person who is the real customer. then upload up Then choose as a target audience for advertising privileges to old customers.

- Used to give special privileges to new customers The case is just the reverse of the first case by setting the normal Targeting first, such as Gender, Age, Interests, and then excludes the Custom Audience generated from the first case.

- Used to present the product to match the behavior that has been purchased. This case is similar to the first case. Just will do Segment separately according to the category of products that have been purchased. In order to send product ads to match the behavior even more.

- To create a Look a like Audience from people who are already customers Because doing a look a like from people who have bought it will result in new Audience who are more likely to buy the product as well.


What is Facebook Custom Audience?

Custom Audiences create an audience for advanced ad impressions. Different from the basic audience selection such as gender, age, interests that the Facebook system provides completely. There are many ways to do Custom Audience. But the method that works well and is very accurate is to upload the mobile phone number that we have on the system of Facebook so that Facebook can map it to the Facebook ID that is tied to the mobile number. From the past experience, when doing Custom Audience in this way, the rate of mapping is quite high at 50-70%. This means that if we have a large number of target audience numbers, mapping with Facebook ID will be will only get more target groups This will allow us to send advertisements to a specific target audience individually from the mobile number we uploaded.


-------------------------------------------------------------------------------------

Interested in online marketing care services | online marketing | complete graphics | can contact us anytime | brand building | online marketing | online marketing plan | brand building | Facebook fan page care | Take care of LINE OA. You can contact us 24 hours a day.

Details of online marketing services

Examples of various brands that we take care of online marketing

---------------------------------------------------------------------------------------


💙 Consult our team 💙

📱Tel : 0840104252 📱0947805680

Office Hotline : 034-900-165 , 02-297-0811 (Monday-Friday)

📨 Inbox : http://m.me/ChatStick.TH

┏━━━━━━━━━┓

📲 LINE: @chatstick

┗━━━━━━━━━┛

4 views

Comentarios


CS_Redesign_คอนเทนต์เดิม2_2.png
CS_Redesign_คอนเทนต์เดิม3.png
Recent Posts