Jifunze Excel TEXTJOIN(): Kuunganisha Text Kwenye Cells Nyingi kwa Separator

Gundua jinsi ya kutumia TEXTJOIN() kwenye Excel kuunganisha text kutoka kwenye cells nyingi na separator. Tazama tutorials zaidi, pakua mifumo ya Excel bure, na pata msaada wa WhatsApp.”

1. TEXTJOIN() Function

TEXTJOIN() inaruhusu kuunganisha text kutoka cells nyingi kwa separator maalumu. Ni bora zaidi kuliko CONCAT() ikiwa unataka comma, space, dash au separator yoyote.

Syntax:

TEXTJOIN(delimiter, ignore_empty, text1, [text2], …)


delimiter = separator unaotaka kutumia (mfano: " ", ", " )

ignore_empty = TRUE ili kupuuza cells zilizo empty, FALSE ili zionekane

text1, text2,… = text strings au references za cells

2. Mfano Rahisi

Mfano 1: Kuunganisha first name na last name kwa space

A B
John Doe
Mary Smith

Formula:

=TEXTJOIN(" ", TRUE, A2, B2)


Result: John Doe

3. Kuunganisha Range ya Cells

Mfano 2: Kuunganisha values kutoka range kwa comma

A
10
20
30

Formula:

=TEXTJOIN(", ", TRUE, A1:A3)


Result: 10, 20, 30

ignore_empty = TRUE inahakikisha empty cells hazionekani

4. Kutumia TEXTJOIN() Pamoja na Formulas Nyingine

Mfano: Kuunda sentence dynamic

=TEXTJOIN(" ", TRUE, "Hello", A2,", your score is", C2)


A2 = John

C2 = 85

Result: Hello John, your score is 85

5. Tips Muhimu

TEXTJOIN() ni rahisi na flexible zaidi kuliko CONCAT() kwa separator.

Inaweza kuunganishwa na IF(), IFERROR(), VLOOKUP(), INDEX(), SWITCH() kuunda dynamic text reports.

Separator inaweza kuwa space, comma, dash, au hata text nyingine.

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