How To Concatenate Text From Two Columns ll Combine Text Two Columns Into One Column #excel

Concatenate Text From Two Columns
Combine Text From More Than Two Columns into One Column
Merge Text In Excel
JointText In Excel
#excel #exceltips #exceltricks #viralvideo #viralshorts #viralshort #viralvideos #viralreels #excelformula #advanceexcel #excelformulasinhindi

1. Method 1: Using the CONCAT Function
Suppose you have data in column A and column B.
In a new column (e.g., column C), type this formula in the first cell
=CONCAT(A1, B1)
Press Enter and then drag the formula down to fill the rest of the rows

2. Method 2: Using the & Operator
In the new column, type:
=A1 & B1
If you want to include a separator like a space or a comma, modify the formula:
=A1 & " " & B1
Press Enter and drag the formula down.

3. Method 3: For Older Excel Versions ()
If you're using an older version of Excel, use the CONCATENATE function:
=CONCATENATE(A1, " ", B1)

4. Using TEXTJOIN (Available in Excel 2016 and later)
The TEXTJOIN function allows you to combine text from multiple ranges or arrays with a specific delimiter (e.g., a comma, space, etc.).
=TEXTJOIN(delimiter, ignore_empty, text1, [text2], …)
delimiter: The character(s) to separate the values (e.g., a comma "," or a space " ").
ignore_empty: TRUE to skip empty cells, FALSE to include them.
text1, [text2], …: The text items or ranges to combine.

Example:
If columns A and B have text and you want to join them with a space:
=TEXTJOIN(" ", TRUE, A1:B1)
This formula will combine the values in A1 and B1, separated by a space

Видео How To Concatenate Text From Two Columns ll Combine Text Two Columns Into One Column #excel канала Hind Technical Guru