Combine two or more cells in Excel and Google Sheets
=CONCATENATE(A2,A3)
A2, A3 = cells which you want to combine. There are other formulas for combining multiple cells. Check example below
Check below for a detailed explanation with pictures and how to use formulas in Excel and Google Sheets.Combine two or more cell in Excel
How to combine two or more cell in Excel?Combine two or more cell in Excel
COMBINE TWO OR MORE CELL — EXCEL FORMULA AND EXAMPLE
COMBINE TWO OR MORE CELL — EXCEL FORMULA AND EXAMPLE
=A2&"-"&A3
=CONCATENATE(A2,"-",A3)
=TEXTJOIN("-",TRUE,A2:A3)
=TRANSPOSE(TEXTJOIN("-",1,A2:A5))
💡 Download the Excel file used in this exercise here.
Combine two or more cell in Google Sheets
How to combine two or more cell in Google Sheets?Combine two or more cell in Google Sheets
COMBINE TWO OR MORE CELL — GOOGLE SHEETS FORMULA AND EXAMPLE
COMBINE TWO OR MORE CELL — GOOGLE SHEETS FORMULA AND EXAMPLE
=A2&"-"&A3
=CONCATENATE(A2,"-",A3)
=TEXTJOIN("-",TRUE,A2:A3)
=TRANSPOSE(TEXTJOIN("-",1,A2:A5))
=ARRAYFORMULA(CONCATENATE(A2:A3&" "))
💡 View the Google Sheets file used in this exercise here.
Other useful Excel and Google Sheets to combine cells and columns data
- Combine multiple columns into one single column
- Combine two or more cells with a line break
- Combine two or more cells and transpose
- Combine data from multiple Google Sheets tabs and get sheet/tab name
- Sum by month
- SUMIF cells if contains part of a text string
- Sum total sales based on quantity & price
- Combine date and time
- Convert 1-12 to month name
- Dynamic current date and time
- Count blank cell
- Count cell between two values
- Combine two or more cell
- Extract left before first space
- Extract the nth words in a text string
- Flip the first and last name
- SUMIF formulas and example
- SUMIFS formulas and example
- COUNTIF formulas and example
- IF formulas and example
- TEXT formulas and example
- CONVERT formulas and example
- Change the negative number to zero
- Change negative to positive numbers
- Calculate percentage changes for containing zero or negative values
- Count cells over 10 characters
- Count cells that are not blank
- Count if cells contain a specific text
- Count cells that begin with a specific text
- COUNTIF based on multiple criteria