Text Manipulationbeginner
Combine address parts into one field with CONCAT
=CONCAT(A2,", ",B2,", ",C2," ",D2)
Function reference
CONCAT in Excel & Google Sheets
CONCAT is used in 1 formula pattern in this library. Browse worked examples below, or use the generator to build a custom variation for your specific data.
1 beginnerBuild a custom CONCAT formula →
When to use CONCAT
- Build a mailing label column from separate address fields, or create a full-name column from first and last name columns.
Worked examples (1)
Common errors with CONCAT
CONCAT vs CONCATENATE
CONCAT is the modern replacement for CONCATENATE and accepts ranges. CONCATENATE requires individual cell references and does not accept ranges.
Missing spaces in result
CONCAT does not add separators automatically. Include your spaces and commas as literal string arguments between each cell reference.
Frequently asked questions
Can CONCAT handle an entire column range?
Yes — CONCAT(A2:A20) joins all non-empty values with no delimiter. Use TEXTJOIN when you need a delimiter between each value.
Need a custom variation?
Describe your specific CONCAT problem and get a formula written for your exact data.
Open generator with CONCAT