Format Phone Number in Google Sheets

[umar]

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.

 

[Pabbly]

Check this thread for formatting phone numbers - https://forum.pabbly.com/threads/how-to-extract-phone-number-from-the-user-submitted-numbers.38/

 

[umar]

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.

 

[Pabbly]

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.

Please share your workflow name so that we can review it.

 

[umar]

AJMP Sheets

 

[Pabbly]

We have created a workflow which will save all the phone number with 6 - https://connect.pabbly.com/workflow/mapping/IjE2NTQ3NSI_3D

 

[umar]

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.

 

[Pabblymember11]

Hey @umar

You can review the following workflow for your concern.

https://connect.pabbly.com/workflow/share/WBBWZF4ZBWQHTQZ8AmcFIg4aAjtQGgFXAGdSQA##

Kindly check this out and let us know if you get stuck at any step.

Thanks!!

 

[umar]

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	[email protected]	01234567890
Siva	[email protected]	0134444444
Jenny	[email protected]	01123456789

As you can see, some phone numbers have 10 digits and some have 11 digits.

Now I want to add number 6 automatically at the beginning of each phone numbers.

The updated phone numbers also should be place automatically next to the original phone number. In a new column.

It will look like this:

Name	Email	Phone	Updated Phone
Ali	[email protected]	0123456789	60123456789
John	[email protected]	01234567890	601234567890
Siva	[email protected]	0134444444	60134444444
Jenny	[email protected]	01123456789	601123456789

Can you help me with this?

 

[Fagun Shah]

Check this video I made for you - https://www.berrycast.com/conversations/fca74e25-b5e9-5654-ae8e-60baac196df6

Here the workflow you can copy - https://connect.pabbly.com/workflow/share/CkJUZgBHVzVUHwBEUxgDYQscUmsHTVMFUjUIGg##

 

[umar]

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 Send On Event is enough?

 

[Fagun Shah]

Yes, if data is coming from third party application you do need to select Auto Send on Schedule. So it will send all new rows once per hour to pabbly connect.