Exercises / Cleaning text · 4 of 13
Show only the last four digits
RIGHT(text, n) returns the last n characters. Combined with &, it builds labels like "•••• 4242".
Your taskIn B2, use RIGHT to build a masked card label: the text "**** " followed by the last 4 characters of the card number in A2. It will be copied down to B6.
Pro
Unlock this exercise and every module after the basics.
Pro opens every exercise in every module, your review schedule, and the final test for the course certificate.
| Row | A | B |
|---|---|---|
| 1 | Card number | Label |
| 2 | 4111 1111 1111 4242 | |
| 3 | 5500 0000 0000 9071 | |
| 4 | 3714 4963 5398 4310 | |
| 5 | 6011 0009 9013 1117 | |
| 6 | 4000 0566 5566 5556 |