Concatenate Strings In Google Sheets

Steps to concatenate strings in Google Sheets

• Step 1: Select any cell where you want the result to appear.
• Step 2: Type =CONCATENATE(, then select the two cells you want to combine. Remember to add a comma (,) between them, close the parentheses, and press Enter.
  Example: =CONCATENATE(A1, B1)
• Step 3: If you want to separate the combined values with a comma, insert "," between the cell references in the formula.
  Example: =CONCATENATE(A1, ",", B1)

Tip: If you want to apply the same formula to other cells, move your cursor to the bottom-right corner of the result cell and drag it down to copy the formula.