formatting mobile phones number

[Feras95p]

Dear all,

I'm looking for a help in formatting a column with name of phone which contains more than 100k cells, I want to delete the first 3 digits which are 966 so to start directly without the country code "which are the first 3 digits" 

Any help in that please ?

[CoG · Accepted solution]

Do you have any other characters in that column? Sample data is important so that you receive the best assistance.

If you are only working with numbers in a string type column, then you can use the Substring([phone],3) function in the Formula Tool to remove the first 3 characters.