Lessons › Excel & Google Sheets
Excel & Google Sheets lesson
LEFT and RIGHT
0803. RIGHT does the same from the end.
Try this lesson free →Example
The first four digits show the network. LEFT takes characters from the start of the text:
=LEFT(C2,4)| Name | City | Phone | Clean | Output |
|---|---|---|---|---|
| Ada Obi | Lagos | 0803-555-1234 | ||
| Tunde Bakare | Abuja | 0706-555-9876 | ||
| Grace Eze | Abuja | 0812-555-4433 | ||
| Musa Bello | Kano | 0901-555-2211 |
Key points
LEFT(C2, 4)The first 4 characters of C2.
RIGHT(C2, 4)The last 4 characters of C2.
The numberHow many characters to take. Spaces and dashes count too.
Put together: =LEFT(C2,4) gives 0803, =RIGHT(C2,4) gives 1234.
Practice
1. In E3, take the first 4 digits of Tunde's phone number.
=LEFT(C3,4)2. In E4, take the last 4 digits of Grace's phone number.
=RIGHT(C4,4)3. In E5, take the first 4 digits of Musa's phone number.
=LEFT(C5,4)4. In D2, take the last 4 digits of Ada's phone number.
=RIGHT(C2,4)5. In D5, take the first 4 letters of Musa's name.
=LEFT(A5,4)Learn it by doing. This lesson is a short hands-on level on Bampaa: see it work, then build and write it yourself, with instant feedback.
Try this lesson free →