Remove country code or first 3 characters from a Google Sheet field
Status: Closed · Asked by Omni Digital on · 0 views
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?
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
hi, where do i input this on Pabbly?
hi, where do i input this on Pabbly
In actions called Number Formula - Spreadsheet Formula