Formulas and Functions
ह्या कंट्रोलमध्ये बदल केल्यामुळे हे पेज ऑटोमॅटिकली अपडेट होईल

TEXTJOIN

The TEXTJOIN function combines the contents of cell ranges or strings with a specified delimiter between each value.

TEXTJOIN(delimiter, ignore-empty, string, string…)

delimiter: A string to add between combined values. delimiter can also be empty, or a reference to a string in another cell.

ignore-empty: A Boolean TRUE or FALSE.

FALSE (0): If FALSE, empty cells are included in the result.

TRUE (1): If TRUE, empty cells aren’t included in the result.

string: Any value. Can also be a cell or a range of cells.

string…: Optionally include one or more additional values or cell references.

Notes

  • Including header cells can cause TEXTJOIN to return an error.

  • As an alternative to the TEXTJOIN function, you can use &, the concatenation operator.

  • To combine the contents of cells without a delimiter, you can also use CONCAT.

Examples

Given A2=1, A3=2, A4=3, B2=A, B3=B, B4=C and C2:C4 are empty:

=TEXTJOIN(" ",TRUE,A,B) returns "1 2 3 A B C".

=TEXTJOIN(A2,TRUE,B) returns "A1B1C".

=TEXTJOIN(",",FALSE,A2:A4,C2:C4,B2:B4) returns "1,2,3,,,,A,B,C".

See alsoCONCAT
Morty Proxy This is a proxified and sanitized view of the page, visit original site.
उपयुक्त आहे का?
कॅरॅक्टर मर्यादा : 250
कमाल कॅरॅक्टर मर्यादा 250 आहे.
तुमच्या प्रतिक्रियेबद्दल धन्यवाद.
Morty Proxy This is a proxified and sanitized view of the page, visit original site.