jinsi ya kutumia MID() kwenye Excel kuchukua characters kutoka katikati ya text. Tazama tutorials zaidi, pakua mifumo ya Excel bure, na pata msaada wa WhatsApp.”

1. MID() Function

MID() inarudisha characters maalumu kutoka katikati ya text string, kuanzia position unayochagua. Ni muhimu kwa parsing text, extracting codes, au dynamic strings.

Syntax:

MID(text, start_num, num_chars)


text = text string au reference ya cell

start_num = position ya kwanza ya character unayotaka kuchukua (1 = first character)

num_chars = idadi ya characters unayotaka kurudisha

2. Mfano Rahisi

Mfano 1: Chukua 3 characters kuanzia position ya 2

A
Excel
MIDFunc
Tutorial

Formula:

=MID(A2,2,3)


Result: xce

A3 → IDF

3. Kutumia MID() Pamoja na LEFT() na RIGHT()

Mfano 2: Extract middle part ya code

A
ABC-1234
XYZ-5678

Formula:

=MID(A2,5,4)


Result: 1234

A3 → 5678

Position 5 = kuanzia baada ya dash, 4 characters zinachukuliwa

4. Kutumia MID() na FIND()

Mfano: Extract text baada ya space au separator

A
John Doe
Mary Smith

Formula:

=MID(A2,FIND(" ",A2)+1,100)


Result: Doe

A3 → Smith

FIND() inapata position ya space, MID() inachukua text inayofuata

5. Tips Muhimu

MID() inasaidia extract characters kutoka katikati ya string.

Inaweza kuunganishwa na LEFT(), RIGHT(), FIND(), LEN(), VALUE(), TEXTJOIN() na formulas nyingine.

Ni muhimu kwa dynamic parsing, codes extraction, na report automation.

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