Can CONCAT join an entire range without listing each cell?

Yes. Supplying a range like A2:A5 as a single argument makes CONCAT stitch every cell in that range together in row-major order. No delimiter is inserted, so you may need TEXTJOIN if you require separators.

Does CONCAT preserve leading or trailing spaces in the source cells?

CONCAT does not trim spaces; any leading or trailing blanks in the source values are retained in the result. Use TRIM on each argument if you need to remove unwanted whitespace before concatenation.

What happens if I concatenate a Boolean value such as TRUE?

Boolean values are coerced to their text equivalents "TRUE" or "FALSE" before being joined. This behavior mirrors how Excel treats numbers and dates during concatenation.

Is CONCAT case-sensitive?

CONCAT simply joins characters; it does not alter case. If you need to force upper-case or lower-case, wrap the result with UPPER or LOWER, or apply those functions to individual arguments.

CONCAT function

CONCAT joins two or more text strings into one continuous string, automatically coercing numbers and dates to text without a delimiter.

=CONCAT(text1, ...)

Generate a CONCAT formula

Describe what you need. The generator will reach for CONCAT where CONCAT is the right tool, and tell you when it is not.

Arguments

How CONCAT reads its arguments

Argument	Required	Description
text1	Required	The first required argument; can be a string, number, date, cell reference, or range, and is coerced to text before joining.
...	Repeating	Optional additional arguments; each may be a literal, cell, range, or expression, and are concatenated in the order supplied.

Returns

It returns a single text string that is the concatenation of all supplied arguments.

Availability

Excel: 2019+ · Google Sheets: Not available

Worked examples

1. Create a readable plan label for each customer

Customer	Plan	MRR	Signup Date	Churn Date
Acme Corp	Pro	1200	2022-01-15
Beta LLC	Basic	500	2022-03-01	2023-02-28

=CONCAT(A2, " (", B2, ")")

Result: Acme Corp (Pro)

The formula takes the value in A2 (Acme Corp) and B2 (Pro), inserts a space, an opening parenthesis, and a closing parenthesis, and concatenates everything. CONCAT automatically turns the numbers and dates into text, but they are not needed here, so the final string is exactly "Acme Corp (Pro)".

2. Generate a simple invoice line from MRR

Customer	Plan	MRR	Signup Date	Churn Date
Acme Corp	Pro	1200	2022-01-15
Beta LLC	Basic	500	2022-03-01	2023-02-28

=CONCAT("Invoice for ", A2, ": $", C2)

Result: Invoice for Acme Corp: $1200

Here CONCAT stitches together a literal prefix, the customer name from A2, another literal, and the numeric MRR from C2. Excel coerces the number 1200 to the text "1200", so the result reads like a short invoice description.

3. Show a subscription timeline, handling ongoing accounts

Customer	Plan	MRR	Signup Date	Churn Date
Acme Corp	Pro	1200	2022-01-15
Beta LLC	Basic	500	2022-03-01	2023-02-28

=CONCAT(A2, ": ", D2, " to ", IF(E2="","present",E2))

Result: Acme Corp: 2022-01-15 to present

The formula concatenates the customer name, the signup date, and either the churn date or the word "present" if the churn cell is blank. IF evaluates E2; when it is empty, the inner CONCAT is skipped and "present" is used, producing a readable timeline for active subscriptions.

Common errors

Which CONCAT error are you seeing?

Error	Why it happens	How to fix it
#N/A	One of the CONCAT arguments contains the #N/A error, which propagates because CONCAT cannot ignore lookup failures.	Wrap the problematic reference with IFERROR or provide a fallback value, e.g., IFERROR(A2, "Unknown").
#REF!	A cell reference used inside CONCAT was deleted, leaving an invalid reference that triggers #REF!.	Restore the missing cell, adjust the formula to point to an existing range, or use INDIRECT with a stable address string.
#DIV/0!	An argument points to a cell where a division by zero error occurred; CONCAT passes that error through unchanged.	Correct the underlying arithmetic, or shield the argument with IFERROR(..., "0") before concatenation.

Tips and when to use something else

Use TEXTJOIN when you need a delimiter between items and want to ignore empty cells.
CONCATENATE works in older Excel versions that lack CONCAT, but it requires each argument to be listed individually.
Numbers and dates are automatically coerced to text, but you can format them first with TEXT for custom display.
Combine CONCAT with IFERROR to produce clean strings even when some inputs contain errors.

Related functions

CONCATENATECONCATENATE joins several text strings into one continuous string, in the order the arguments are supplied, and returns it as a single text value.TEXTJOINTEXTJOIN merges multiple text strings or ranges into one string, using a chosen delimiter and optional ignoring of empty cells.LEFTLEFT returns the leftmost characters from a text string, optionally limited by a specified number of characters.VLOOKUPVLOOKUP searches the first column of a table and returns a value from a specified column in the same row, optionally using exact or approximate matching.XLOOKUPXLOOKUP returns the value from a specified return array that corresponds to a given lookup value, with optional handling for missing matches and search direction.

Frequently asked questions

Can CONCAT join an entire range without listing each cell?: Yes. Supplying a range like A2:A5 as a single argument makes CONCAT stitch every cell in that range together in row-major order. No delimiter is inserted, so you may need TEXTJOIN if you require separators.
Does CONCAT preserve leading or trailing spaces in the source cells?: CONCAT does not trim spaces; any leading or trailing blanks in the source values are retained in the result. Use TRIM on each argument if you need to remove unwanted whitespace before concatenation.
What happens if I concatenate a Boolean value such as TRUE?: Boolean values are coerced to their text equivalents "TRUE" or "FALSE" before being joined. This behavior mirrors how Excel treats numbers and dates during concatenation.
Is CONCAT case-sensitive?: CONCAT simply joins characters; it does not alter case. If you need to force upper-case or lower-case, wrap the result with UPPER or LOWER, or apply those functions to individual arguments.

Need a different formula?

The full generator is not scoped to one function — describe any spreadsheet problem and it will pick.

Open the formula generator

Reviewed 2026-09-17