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

[yang_yang74]

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]

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

 

[yang_yang74]

hi, where do i input this on Pabbly?

 

[Fagun Shah]

hi, where do i input this on Pabbly?

In actions called Number Formula - Spreadsheet Formula