Open your spreadsheet in Microsoft Excel. Locate the text you wish to concatenate. As an example, you might have text in cells A1 and A2. Type "=CONCATENATE(A1,A2)" in an empty cell to concatenate ...

If you’re using Excel 2019 through Microsoft 365, there’s a function that can do the same thing, only quicker and with no helper column. How to combine values into a single cell using TEXTJOIN ...

Concatenate merges the data you have inserted into columns into its own cell or column in Excel. Let’s take a look at how to use concatenate in Excel.

3] Use the Concatenate function to join and add a comma between words You can also add a comma between your words by using the formula =CONCATENATE(A3, ” “, B3, “,”, 90) .

TEXTJOIN function is available in Excel for Office 365, Excel 2019, and Excel 2021. The syntax of ... So the function will pick cell value A3 (Singh), concatenate it with a comma character ...

For example, if a comma were between the quotation marks, like this: =CONCATENATE(A2,","B2) then the data from cell A would be separated from the data in cell B by a comma.