Text Manipulationbeginner
Combine address parts into one field with CONCAT
=CONCAT(A2,", ",B2,", ",C2," ",D2)
Worked examples (1)
These formulas work in Google Sheets with identical syntax.
Also in Excel
See the full CONCAT reference for Excel — including all worked examples, common errors, and FAQ.
CONCAT Excel reference →