Join columns with CONCAT or &
CONCAT joins the values you give it into one text value. The & operator does the same and also works in older versions and in Google Sheets with more than two parts.
=CONCAT(A2," ",B2)The sheet: Column A is First name and column B is Last name. You want a full name in one cell.
How it works, step by step
- 01A2 is the first name.
- 02" " adds a space between the names.
- 03B2 is the last name.
- 04The result is a single piece of text such as Ada Lovelace.
The same logic in four tools
=CONCAT(A2," ",B2)=A2&" "&B2SELECT CONCAT_WS(' ', first_name, last_name) AS full_name
FROM people; -- PostgreSQL, MySQLdf["full_name"] = df["first_name"] + " " + df["last_name"]Mistakes that break it
- !Google Sheets CONCAT accepts only two arguments, so use & or JOIN for three or more parts.
- !CONCAT does not add separators. If you need a delimiter between many cells, TEXTJOIN does it.
- !A blank last name leaves a trailing space. Wrap the result in TRIM.
- !In pandas, a missing value makes the whole joined result missing.
Common questions
- Is CONCATENATE still available?
- Yes, it works but CONCAT replaced it in Excel 2019 and later, and & works everywhere.
- How do I join a number and text?
- The & operator converts the number automatically. Use TEXT to control its format, such as TEXT(B2,"0.00").
Got a version of this with your own ranges?
Paste it into the free translator and get the same breakdown for your exact formula. To run it against a real file, upload the CSV and describe the formula you need in a sentence.