• Instructions to Ask a Question

    Click on the "Ask a Question" button and select the application for which you would like to ask questions.

    We have 5 different products namely - Pabbly Connect, Pabbly Subscription Billing, Pabbly Email Marketing, Pabbly Form Builder, Pabbly Email Verification.

    The turnaround time is 24 hrs (Business Hours - 10.00 AM to 6.00 PM IST, Except Saturday and Sunday). So your kind patience will be highly appreciated!

    🚀🚀Exclusive Discount Offer

    Just in case you're looking for any ongoing offers on Pabbly, you can check the one-time offers listed below. You just need to pay once and use the application forever -
     

    🔥 Pabbly Connect One Time Plan for $249 (🏆Lifetime Access) -  View offer 

    🔥 Pabbly Subscription Billing One Time Plan for $149 (🏆Lifetime Access) - View offer

Remove country code or first 3 characters from a Google Sheet field

Hi, I have a FB lead form to Google sheet work flow.
I need to remove the country code from all mobile numbers from the FB Lead form entry before passing to Google Sheets
How can I do this?
 

Fagun Shah

Well-known member
I am assuming your mobile numbers have same digits without country code. For example Indian mobile numbers have 10-digits without country code. So we use this - Number Formula - Spreadsheet Formula

RIGHT('+91-9909999099',10)

Output - 9909999099
 
Top