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.