Text › RIGHT50 / 144

Progress is saved on this device. Sign in or sign up free to keep it in your account.

EasyFreeRIGHT

RIGHT: last 4 digits of a phone number

Mira runs a pay-by-weight laundry in Bekasi. For privacy, receipts do not show the full customer phone number; they only print **** followed by the last 4 digits, which is enough to match customers when they pick up their laundry.

Task

Fill C2:C6 with **** followed by the last 4 digits of the phone number in column B, for example ****7890. Use RIGHT.

Cells to fillC2:C6

Required functionsRIGHT

Expected result

Loading the expected result…

Check answerCtrlShiftEnter
Fill downCtrlD
Previous / next exerciseAlt←→
Leave the workspaceEscTab

Hint 1
RIGHT(text, n) takes n characters from the right of the text.
Hint 2
The phone numbers in column B are stored as text, so the leading 0 is kept and RIGHT works directly.
Hint 3
Join the text "****" with the result of RIGHT using &.

Reveal them one at a time. The last hint nearly gives the answer away.

Give it a try first. The solution unlocks automatically after your first check.

Answer

C2:C6

="****"&RIGHT(B2,4)

Write it in C2, then fill down to C6.

Explanation

=RIGHT(B2,4) takes the last 4 characters, and & attaches them after "****". Because the number is text, the result is text too, so digits like "0011" stay intact. If phone numbers were stored as numbers, the leading zero would already be gone, so keep phone numbers as text. The siblings of RIGHT are LEFT (from the left) and MID (from the middle).

Starting worksheet: Sheet1
Row	A	B	C
1	Customer	Phone no.	On receipt
2	Hana	081234567890
3	Wahyu	085611223344
4	Citra	087788990011
5	Joni	081311119876
6	Melda	089912345432
7
8
9
10
11
12
13
14

Fill in the requested cell, then press Check answer.

Validation result