How it works.
CONCAT is the modern replacement for CONCATENATE. It lets you join list of strings or ranges. Unlike CONCATENATE, it supports range parameters (e.g. A2:C2). It does not include delimiters automatically; use TEXTJOIN for delimited lists.
💡 In simple terms.
Glues multiple pieces of text from different cells together into a single cell, without any spacing in between.
"Think of this like gluing Lego blocks together. You take two separate blocks (Username and Domain) and snap them into one long block."
Syntax guide.
Parameters
The first text item or cell range to combine.
Additional strings, delimiters, or ranges (up to 253 arguments).
Optional third range or string.
Interactive formula builder.
Fill in the input arguments below to construct your custom formula string. Copy it directly to paste into your Excel spreadsheets.
Best Practices
- To insert a space or custom character between combined cells, include it as a separate argument in quotes (e.g. `=" "` or `"-"`).
- Use the ampersand `&` operator as a quick shortcut for CONCAT (e.g. `=A2 & "@" & B2`).
Common Gotchas
- CONCAT does not skip blank cells. If you select a range containing empty cells, they will be output as empty sections in the resulting text.