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) .

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.

The syntax to add a comma after first word in each cell in Excel using the Replicate function is as follows: =REPLACE(<first cell in which you need to add comma>,FIND(" ",<first cell in which you ...

Instead, you need to use the CONCATENATE formula to combine that data. In the Excel worksheet where you want to combine two columns of data, first insert a new column near the data you want to ...