Fix Excel CONCATENATE Formula Appearing as Text on Mac
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.

- 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 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.
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.
Click on the cell that is displaying the CONCATENATE formula as text.
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'.
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.

Disable the Show Formulas Feature
The 'Show Formulas' auditing tool forces all cells in the worksheet to display their underlying formulas rather than their final results.
Verify Formula Syntax
A spreadsheet will not recognize a formula if it lacks the required mathematical prefix.
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. Open your file in WPS Office: Launch WPS Spreadsheet and open your existing workbook containing the data you want to combine.
- 2. Set cell format to General: Right-click your target cell, select 'Format Cells', and ensure the category is set to 'General'.
- 3. Enter the formula: Type =CONCATENATE(A1, B1) and press Enter. WPS Spreadsheet will instantly calculate and display the combined text.

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.




