FORMULA & SQL / TEXT
Combine two columns into one.
Tested, not guessed.
The Excel and Google Sheets formula and the SQL query, each run on the rows below. Open this with your own data ↗
The example rows
| Row | A: Region | B: Rep | C: Amount | D: Order Date | E: Status | F: Customer |
|---|---|---|---|---|---|---|
| 2 | North | Ana | 1,200 | 2026-03-01 | Paid | Jo Smith |
| 3 | South | Ben | 450 | 2026-03-15 | Open | Raj Patel |
| 4 | North | Cy | 300 | 2026-04-02 | Paid | Lee Wong |
| 5 | East | Ana | 980.50 | 2026-04-20 | Paid | Mia Ross |
| 6 | North | Ben | 75 | 2026-05-05 | Open | Jo Smith |
| 7 | West | Dee | 1,640 | 2026-05-18 | Paid | Sam Okoro |
The formula
Excel
=A2&" "&C2
Region (A2) joined with " " joined with Amount (C2).
Run on the example rows:
| Row | Result |
|---|---|
| 2 | North 1200 |
| 3 | South 450 |
| 4 | North 300 |
| 5 | East 980.5 |
| 6 | North 75 |
| 7 | West 1640 |
The SQL
PostgreSQL
SELECT region || ' ' || amount AS combined FROM sales
Run on the example rows:
| combined |
|---|
| North 1200.0 |
| South 450.0 |
| North 300.0 |
| East 980.5 |
| North 75.0 |
| West 1640.0 |
Other databases
MySQL
SELECT CONCAT(region, ' ', amount) AS combined FROM sales
SQL Server
SELECT CONCAT(region, ' ', amount) AS combined FROM sales
SQLite
SELECT region || ' ' || amount AS combined FROM sales
BigQuery
SELECT CONCAT(region, ' ', amount) AS combined FROM sales
Snowflake
SELECT region || ' ' || amount AS combined FROM sales
Your own data
Paste your rows into the free tool and it writes this for your columns, then runs it on your data before you copy it. Open the tool ↗