We want to extract the dialing code of cells. The dialing code is the first 3 digits of the phone number. To extract these figures, we will use the function LEFT.
Function has the following writing:
It is also possible to extract a part of a string inside it. To do that, you will use MID function.
In parameters of this function, you must
- in first, put the reference of your cell
- on the second, indicate the position where you want to start your extraction
- on third, precise number of characters you want to extract
In this example, figure 20 represents number of characters between the first character of the cell and the beginning of the mobile phone number. And 8 represents the 7 figure + the dash.