jinsi ya kutumia RIGHT() kwenye Excel kutoa characters kutoka mwisho wa text. Tazama tutorials zaidi, pakua mifumo ya Excel bure, na pata msaada wa WhatsApp.”
1. RIGHT() Function
RIGHT() inarudisha characters chache kutoka mwisho wa text string. Ni muhimu kwa extracting codes, numbers, au extensions kutoka kwa text cell.
Syntax:
RIGHT(text, [num_chars])
text = text string au reference ya cell
num_chars = idadi ya characters unayotaka kurudisha (default = 1)
2. Mfano Rahisi
Mfano 1: Chukua last 3 characters
A
John123
Mary456
Ali789
Formula:
=RIGHT(A2,3)
Result: 123
A3 → 456
3. Kutumia RIGHT() Pamoja na LEFT() na MID()
Mfano 2: Extract file extension
A
report.xlsx
data.csv
Formula:
=RIGHT(A2,4)
Result: .xlsx
A3 → .csv
RIGHT inasaidia kuchukua extensions au last characters kutoka text
4. Kutumia RIGHT() na VALUE()
Mfano: Extract number kutoka mwisho wa string
A
ABC123
XYZ456
Formula:
=VALUE(RIGHT(A2,3))
Result: 123
A3 → 456
Hii ni muhimu wakati unataka numbers kutoka mwishoni mwa text strings
5. Tips Muhimu
RIGHT() inasaidia extract text kutoka mwisho wa string.
Inaweza kuunganishwa na LEFT(), MID(), FIND(), LEN(), VALUE(), TEXTJOIN(), na formulas nyingine.
Ni rahisi kwa report automation, codes, numbers extraction, au parsing data.
Links Muhimu
Tazama tutorials zaidi za Excel: https://www.faulink.com
Download mifumo ya Excel bure: https://www.faulink.com/excel_mifumo.php
Msaada wa WhatsApp: https://wa.me/255693118509