Search results

  1. umar

    Format Phone Number in Google Sheets

    Auto Send on Schedule This option allows sending data being added from an external source to Google Sheet with a time interval of 1 hr. Open the sheet from where you want to send data, and then enable this option. So do I need to choose this as the data comes from Aweber? Or choosing only...
  2. umar

    Format Phone Number in Google Sheets

    Sorry this is not the solution Im looking for. Let me start my question all over again so that you can really understand it. When my prospects submit a form, the data will go to a Google Sheet. It will look something like this: Name Email Phone Ali [email protected] 0123456789 John...
  3. umar

    Format Phone Number in Google Sheets

    Few problems with this solution: 1) This is a good solution for phone number with 10 digits. But here in Malaysia, we also have phone number with 11 digits. 2) Can the updated phone number to be put next to the original phone number? I mean on the new column.
  4. umar

    Format Phone Number in Google Sheets

    AJMP Sheets
  5. umar

    Format Phone Number in Google Sheets

    In that thread, it shows how to extract phone number. What I need to know is how can I add number 6 on every number automatically? On every number that doesn’t starts with 6.
  6. umar

    Format Phone Number in Google Sheets

    Hi, When someone submit a form through Aweber, the data will go to a Google Sheets. As you can see from the image above, some phone number starts with 0 and some starts with 6. I want all phone number to start with 6. So how can I format it like that? Thank you.
Top