SheetSense

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.

fx
=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

  1. 01A2 is the first name.
  2. 02" " adds a space between the names.
  3. 03B2 is the last name.
  4. 04The result is a single piece of text such as Ada Lovelace.

The same logic in four tools

Excel
=CONCAT(A2," ",B2)
Google Sheets
=A2&" "&B2
SQL
SELECT CONCAT_WS(' ', first_name, last_name) AS full_name
FROM people;  -- PostgreSQL, MySQL
Python (pandas)
df["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.