Excel में Text कैसे जोड़ें Concatenate, &, Concat, TextJoin

Description:
???? FREE Excel Webinar. REGISTER NOW
https://event.webinarjam.com/register/13/m4851s2

We can join text using Concatenate, &, Concat and TextJoin function in Excel. Although CONCAT and TEXTJOIN functions are available only in Office 2016, 2019 & Office 365 versions.

Download the excel file here: https://learn-with-lokesh-lalwani.thinkific.com/pages/downloadable-files

Let's have a look at the syntax and arguments of the functions:

CONCATENATE:

Use CONCATENATE, one of the text functions, to join two or more text strings into one string.

Syntax: CONCATENATE(text1, [text2], ...)

text1 (required)

The first item to join. The item can be a text value, number, or cell reference.

Text2, ... (optional)

Additional text items to join. You can have up to 255 items, up to a total of 8,192 characters.


CONCAT:

This function replaces the CONCATENATE function. However, the CONCATENATE function will stay available for compatibility with earlier versions of Excel.

The CONCAT function combines the text from multiple ranges and/or strings, but it doesn't provide the delimiter or IgnoreEmpty arguments.

Syntax: CONCAT(text1, [text2],…)

text1
(required)

Text item to be joined. A string, or array of strings, such as a range of cells.

[text2, ...]
(optional)

Additional text items to be joined. There can be a maximum of 253 text arguments for the text items. Each can be a string, or array of strings, such as a range of cells.

TEXTJOIN:

The TEXTJOIN function combines the text from multiple ranges and/or strings, and includes a delimiter you specify between each text value that will be combined. If the delimiter is an empty text string, this function will effectively concatenate the ranges.

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

delimiter
(required)

A text string, either empty, or one or more characters enclosed by double quotes, or a reference to a valid text string. If a number is supplied, it will be treated as text.

ignore_empty
(required)

If TRUE, ignores empty cells.

text1
(required)

Text item to be joined. A text string, or array of strings, such as a range of cells.

[text2, ...]
(optional)

Additional text items to be joined. There can be a maximum of 252 text arguments for the text items, including text1. Each can be a text string, or array of strings, such as a range of cells.

For more such videos subscribe to our channel: https://www.youtube.com/channel/UCFAr3FQxRhSzVNOD3vq1gMQ/featured?sub_confirmation=1

Follow me on Instagram: https://www.instagram.com/learnwithlokeshlalwani/?hl=en
______________________________________________________________________
⚠️ Disclaimer:
Ye video sirf educational purpose ke liye hai. Jo earnings mention ki gayi hain, wo estimated figures aur personal experience par based hain. Aapki actual earnings aapke effort, market demand aur platform policies par depend karegi. Is video mein kisi bhi guaranteed income ka promise nahi hai. Koi bhi online earning method shuru karne se pehle apni research zaroor karein.

???? Video pasand aaye to Like, Share & Subscribe zaroor karein!
???? Agar koi sawaal hai, to comment section mein pooch sakte hain!

#EarnOnline #SecondSalary #Freelancing #SideIncome #PassiveIncome