Use it to construct display names, labels, shipment descriptions and identifiers from clean source columns while leaving originals untouched. Put delimiters such as spaces, hyphens and parentheses inside quotes as their own arguments. If you need to join a whole range while ignoring empty cells, compare the separately documented TEXTJOIN instead; do not assume all range or blank handling is interchangeable.

=CONCATENATE(text; [text1]; ...)

Zoho documents =CONCATENATE("Zoho";" ";"Sheet") returning Zoho Sheet and permits the & operator as an alternative. The reference does not specify a Zoho maximum argument count or resultant character length; do not transfer Excel limits into a Zoho claim.

Version, platform and locale scope

The syntax below is taken from Zoho Sheet’s current public English online function reference checked October 11, 2026. That reference does not identify the first Zoho release supporting this function or prove identical behaviour across historical releases, desktop wrappers, iOS, Android, or account configurations. No such first-supported version is claimed here. The published Zoho examples use semicolons (;) between arguments; syntax displayed by a localized application should be checked in its formula helper rather than copying separators from Excel. Zoho documents spreadsheet locale controls for number, date, currency, and decimal formats. Do not assume text that looks like a number will parse identically under all locales. Zoho locale settings.

Use a new Zoho Sheet spreadsheet. Create these six column headings in row 1, then enter the eight example rows. Select column E as text before entering values, because these are intentionally imported-looking numeric strings; a CSV import may otherwise turn them into numbers. Keep order identifiers in A as text. If importing the included CSV, inspect column types afterward and correct them before comparing formulas. The examples use fictitious records only.

A formula such as =B2 references the first data row, not the header. Enter examples in blank cells, or create a separate Results sheet and select the sample cells to form explicit references. When copying a formula down, check the references advance to the correct rows. Set result cells to General where you want to see the returned value without extra display formatting.

1. In G2, enter =CONCATENATE(B2;" ";C2) and press Enter. Expected: Ada Ng. Inspect that the whitespace between the names comes from " ".
2. In G3, enter =CONCATENATE(B3;" ";C3). Expected: Ben Li.
3. In a fresh result cell, use =CONCATENATE(A2;" | ";B2;" ";C2). Expected: ORD-001 | Ada Ng.
4. Use =CONCATENATE("Qty: ";D2). Expected: Qty: 3. This uses a numeric cell as input; Zoho’s official concatenation example likewise joins a numeric cell to text.
5. Test =B2&" "&C2 for the same Ada Ng expected output; Zoho explicitly documents & as an alternative joining operator.

Advanced application: descriptive shipping label

Suppose the package packing slip needs the order ID, full recipient name and quantity. First verify A2 is still ORD-001, and D2 is the numeric 3. Use:

=CONCATENATE("Order ";A2;" / ";B2;" ";C2;" / Qty ";D2)

Expected result: Order ORD-001 / Ada Ng / Qty 3. This is a display label, not a validation rule: if A2 is wrong or incomplete, CONCATENATE carries the wrong source value into the label. Keep source ID and numeric quantity independently available for filtering and sorting.

Limitations and data integrity: This function assembles text; it does not trim whitespace, format a date consistently, validate IDs or make an invalid number safe. Ensure you know whether you are joining the displayed number format or the underlying value. Avoid assuming Excel range-handling behaviour in Zoho without a specific official citation.

Excel documents CONCATENATE(text1, [text2], ...) with commas in its English examples and recommends the newer CONCAT function in many Excel versions, while preserving CONCATENATE for backward compatibility. Zoho’s documented CONCATENATE remains a supported function and its shown separators are semicolons. Both products offer &; do not assume their exact string length limits, locale conversions or range-array support are identical. In Google Sheets, manually check function separators and locale too rather than pasting an Excel formula unmodified.

Quick questions

Does CONCATENATE automatically insert a space? No: add " " where you want one.

Does it overwrite my original data? No; a formula entered in G2 returns a new value and leaves B2 and C2 untouched.

Can I use & instead? Yes, Zoho documents & for concatenation, often clearer for short labels.

• CONCATENATE — join several text values.
• REPT — repeat text without building a string manually.
• CHAR — get a character from its numeric code.
• CODE — inspect the first character’s code.
• VALUE — convert text representing a number into a numeric result.
• LEFT, LEN, TEXTJOIN, and TRIM — related text tools under review.

• Zoho Sheet — function documentation
• Zoho locale settings

Verification status: Official documentation checked; example outcomes were independently reasoned or arithmetically checked where applicable. Not executed in Zoho Sheet.

• No genuine Zoho Sheet screenshots are included; this guide does not use mock application images.