Formula Errors

Fix Excel CONCATENATE Formula Appearing as Text on Mac

Rana GarciaRana Garcia Nov 3, 2026 869 views

Question details

The user is trying to use the CONCATENATE formula in an older workbook, but the cell is displaying the actual formula string instead of the calculated text output.

How to Fix Excel CONCATENATE Formula Appearing as Text on Mac
Product
Excel
Device & OS
Mac
Scenario
Combining text data using the CONCATENATE function in a spreadsheet.
Observed behavior
The formula appears as plain text in the cell and fails to calculate or combine the referenced data.
Before you start

Before proceeding, double-click the affected cell to check if there is an accidental space or a hidden apostrophe (') placed right before the equals sign, as this instantly converts the formula to text.

Solution 1Recommended

Change Cell Format to General and Recalculate

If a cell is pre-formatted as Text or Number, Excel will treat any entered formula as a literal text string. Converting it to General format resolves this issue.

In many older workbooks or exported reports, columns are often formatted as Text by default to prevent data loss. When you type a formula into these cells, the spreadsheet engine ignores the calculation.

1
Select the affected cell

Click on the cell that is displaying the CONCATENATE formula as text.

2
Change the number format

Navigate to the Home tab on the Excel ribbon. Locate the Number format dropdown menu and change the selection from 'Text' or 'Number' to 'General'.

3
Force the recalculation

Changing the format alone won't update the cell immediately. Double-click the cell to enter Edit mode (or click inside the Formula Bar), then press the Return key to execute the formula.

Change Cell Format to General and Recalculate
Pro Tip: To avoid this issue in the future, always verify that the target cell is formatted as 'General' before you start typing your formulas.
Smart Spreadsheet Tool

Use WPS Spreadsheet to Concatenate Data Seamlessly

WPS Spreadsheet provides full compatibility with all standard formulas, including CONCATENATE and CONCAT, and features intelligent formatting detection to prevent calculation errors.

  1. 1. Open your file in WPS Office: Launch WPS Spreadsheet and open your existing workbook containing the data you want to combine.
  2. 2. Set cell format to General: Right-click your target cell, select 'Format Cells', and ensure the category is set to 'General'.
  3. 3. Enter the formula: Type =CONCATENATE(A1, B1) and press Enter. WPS Spreadsheet will instantly calculate and display the combined text.
100% compatible with Microsoft Excel formulas and file formatsSmart cell formatting prevents formulas from rendering as textFree, lightweight, and fast alternative to Microsoft Office
microsoft office alternative - wps office

Frequently Asked Questions

Why do all formulas in my workbook suddenly appear as text?

This usually happens if the 'Show Formulas' auditing mode was accidentally activated. You can instantly disable it by navigating to the Formulas tab and deselecting 'Show Formulas', or by pressing the 'Ctrl + `' keyboard shortcut on your Mac.

I changed the cell format to General, but the formula is still plain text. What did I miss?

Changing a cell's format does not retroactively update the existing text inside it. You must force the spreadsheet to re-evaluate the cell by double-clicking it to enter Edit mode, and then pressing the Return/Enter key.

Can I use CONCAT instead of CONCATENATE?

Yes. CONCAT is a newer, shorter, and more flexible version of the CONCATENATE function. It is highly recommended to use CONCAT or TEXTJOIN in modern spreadsheet software like Excel and WPS Office.