CONCAT and TEXTJOIN in Excel on Mac: Step-by-Step

Most tutorials about CONCAT and TEXTJOIN assume you're on Windows and just forgot to mention it. If you're on a Mac and a formula isn't working, that omission is probably why. This guide is written for Excel on Mac specifically, and before you type a single formula, the version question matters more here than on any other platform. Both the CONCAT function and the TEXTJOIN function require Microsoft 365 for Mac, Office 2021 for Mac, or Office 2019 for Mac. If you're running an older version, neither function exists in your copy of Excel. Your fallback is CONCATENATE, which works back to Excel 2007 and still gets the job done for basic joining. (CONCATENATE still works. It just makes you type more and feel worse about it.)

What you'll be building here: formulas that combine cells in Excel on Mac, joining first names with last names, building address strings, creating comma-separated lists from a range, with and without delimiters, and with proper handling of blank cells. If you've ever watched a colleague copy-paste text across columns manually every Friday afternoon, this is the thirty-second fix for that.

If you're newer to Excel formulas generally, the Excel Formulas and Functions for Beginners overview is worth a quick read before you continue.

---

Step 1: Use CONCAT in Excel on Mac to Join Text Without a Delimiter

How to Enter CONCAT in the Mac Formula Bar

Click the cell where you want the combined result. Click into the formula bar at the top of the screen, or just start typing and Excel will route your input there automatically. Type =CONCAT( and then select your cells or range. A simple example:

=CONCAT(A2," ",B2)

This joins whatever is in A2 with a space and then B2. Press Return to confirm.

One thing that trips people up on Mac specifically: if you press Escape to cancel a formula mid-entry, Excel discards the whole thing. If you've already confirmed a formula and want to undo it, Command+Z works fine. Escape and undo are not the same thing in the formula bar.

When to Use CONCAT Instead of CONCATENATE

The practical difference is range support. CONCATENATE forces you to list every cell individually:

=CONCATENATE(A2,B2,C2,D2)

CONCAT accepts a range directly:

=CONCAT(A2:D2)

For four cells that's minor. For twenty cells across a row, it's the difference between a readable formula and a mess. CONCAT has been the better default for text joining since Office 2019, assuming your version supports it.

If your Mac shows #NAME? when you type CONCAT, that's a version error — your Excel doesn't recognize the function. Switch to CONCATENATE, or check your version under Excel → About Microsoft Excel from the menu bar.

---

Step 2: Use TEXTJOIN in Excel on Mac to Combine Cells with a Delimiter

Once you've got CONCAT working, TEXTJOIN is the natural next step. It solves a problem CONCAT can't.

Setting the Delimiter and the Ignore-Empty-Cells Argument

TEXTJOIN takes three arguments: the delimiter, whether to ignore empty cells, and the range. A practical example: say you have a list of department members in A2:A10 and you want a single comma-separated string:

=TEXTJOIN(", ",TRUE,A2:A10)

The TRUE in the middle is the ignore_empty argument. This is the feature that actually matters. Set it to FALSE and every blank cell in your range produces an extra delimiter in the output: "Sarah, Tom, , , David," which looks wrong and usually breaks whatever you're doing with the result downstream. Set it to TRUE and blank cells disappear cleanly.

TRUE means "skip blanks." FALSE means "include a delimiter slot for every blank anyway." Almost every real-world use case wants TRUE.

If the combined string will feed into a lookup later, wrap your source values in TRIM as well:

=TEXTJOIN(", ",TRUE,TRIM(A2:A10))

Trailing spaces in source data are invisible and will silently break XLOOKUP or VLOOKUP matches. It's worth building that habit early. Speaking of lookups, combining TEXTJOIN with IF conditions is where things get genuinely useful — which is exactly what Step 3 covers.

---

Step 3: Enter a TEXTJOIN Array Formula on Mac to Combine Cells Conditionally

You can nest an IF inside TEXTJOIN to combine only cells that meet a condition. Say column A has department names and column B has employee names, and you want a single string of everyone in Sales:

=TEXTJOIN(", ",TRUE,IF(A2:A10="Sales",B2:B10,""))

On Windows, you'd confirm this with Ctrl+Shift+Enter to enter it as an array formula. On Mac, the shortcut is Command+Shift+Return. That's the Mac-specific detail almost no tutorial mentions, and it's exactly the kind of thing that makes this formula silently fail: press regular Return and the formula evaluates only the first cell in the range instead of the whole array, returning a wrong result with no error message to explain why.

If you're on Microsoft 365 for Mac (the most common business setup as of 2026), dynamic array support means you may not need Command+Shift+Return at all — Excel handles arrays automatically. But if your formula returns only one result when you expected several, try the keyboard shortcut. It'll usually fix it.

Apple Numbers does not support Excel-style array formulas. This step applies to Microsoft Excel on Mac only.

---

Common Mistakes with CONCAT and TEXTJOIN in Excel on Mac

The most common issue is version mismatch. If CONCAT is not available in your Excel for Mac, go to Excel → About Microsoft Excel. You need Office 2019, 2021, or Microsoft 365. On an older license, CONCATENATE is your only option without upgrading.

One error worth calling out separately: a #VALUE error that persists after fixing syntax almost always means your range contains a date stored as a serial number. Dates in Excel are numbers under the hood, and CONCAT will return something like "44927" instead of "1/1/2023." Wrap the date reference in TEXT() to fix it:

=CONCAT(TEXT(A2,"mm/dd/yyyy")," ",B2)

That's not obvious from the error message, but it's almost always the answer.

If you're still getting your bearings with Excel on Mac generally, the Excel for Beginners starter guide covers the interface differences that matter most before you start writing formulas.

---

---

If you take one thing from this article: set the ignore_empty argument to TRUE in every TEXTJOIN formula unless you have a specific reason not to. That single argument is the reason TEXTJOIN replaced every workaround that came before it.