Written and reviewed by FormulaCraft Team. Each formula on this page is run through our verification engine before publishing.
Last reviewed:
CONCAT
CONCAT combines any number of text values, cell references, or ranges into a single string, treating each argument consecutively with no separator added automatically. It is the modern replacement for CONCATENATE and supports entire ranges, making it more concise when merging many cells at once.
Excel
=CONCAT(A2," ",B2)Google Sheets
=CONCAT(A2," ",B2)Try it with your data
Edit the grid or formula, then run it through a real spreadsheet engine — no signup.
Sample data — click any cell to edit
Runs server-side · free · no signup
How it works
- 1Identify the text values or cell ranges you want to join.
- 2If you need a separator between items, include it as a text literal between arguments (e.g., ", " or " ").
- 3Enter =CONCAT(text1, text2, ...) with up to 253 arguments to produce the merged string.
Need a version for your data?
Try: “Combine first name and last name columns into a single full name column”