Formula Errors

How to Fix Excel IF Formula Quotation Marks Disappearing

Maira Mehtab Sep 22, 2026 869 views

Question details

Users report that quotation marks around text values in Excel IF formulas automatically disappear after a recent security update.

Product: Microsoft Excel
Device & OS: not provided
Scenario: Writing or modifying IF formulas containing text string values in an updated version of Microsoft Excel.
Observed behavior: Quotation marks are unexpectedly stripped from the IF statement syntax, potentially causing the formula to fail or return unintended results.

Before you start

Check your exact Microsoft Office version and build number under File > Account, and prepare a sanitized test workbook without sensitive data to safely troubleshoot the issue.

Solution 1Recommended

Isolate the Issue Using Safe Mode and a New Workbook

Testing in Safe Mode helps determine if the issue is caused by interfering add-ins, while using a new workbook rules out file-specific corruption.

Since this bug is highly specific to IF statements, isolating the environment is the first critical step before attempting any software rollbacks.

Launch Excel in Safe Mode

Press the Windows key + R to open the Run dialog. Type 'excel /safe' and press Enter. This opens Excel without loading any third-party add-ins.

Test the IF Formula

Create a new, blank workbook. Type a simple IF statement containing text values (e.g., =IF(A1=1, "Yes", "No")) and verify if the quotation marks remain intact upon pressing Enter.

Cross-Test on Another Machine

If possible, send the sanitized test file to another computer running a different version of Office (such as Microsoft 365) to see if the issue replicates.

Microsoft 365 Compatibility: This specific quotation mark disappearance issue generally does not reproduce in Microsoft 365 Excel, indicating it may be tied to a patch on a standalone Office release.

Solution 2

Perform a Temporary Office Rollback

If the issue started immediately following a security update, reverting your Office installation to the previous build can restore formula functionality.

Free Microsoft Office alternative

Try WPS Office to Avoid Update-Related Formula Bugs

If you are frustrated by unexpected bugs like disappearing quotation marks in Excel after updates, consider switching to WPS Office. It provides a stable, highly compatible spreadsheet environment without the disruptive update glitches.

1. Download and Install WPS Office: Visit the official WPS website and download the free version of WPS Office.
2. Open Your Affected Workbook: Launch WPS Spreadsheet and open your existing Excel (.xlsx) file.
3. Edit Your Formulas Safely: Edit or insert your IF formulas; WPS Spreadsheet will correctly retain your quotation marks and syntax.

Highly compatible with Microsoft Excel formats (.xlsx, .xls, .csv).Reliable formula engine that correctly processes IF statements and text strings.Lightweight installation and smooth performance without forced bug-inducing updates.Free to download and use with a familiar, easy-to-learn user interface.

microsoft office alternative - wps office

Frequently Asked Questions

Why do quotation marks disappear in Excel IF formulas?

This occasionally happens due to bugs introduced in recent security or Office updates, which inadvertently affect how Excel parses specific formula syntax in standalone desktop versions.

Does this quotation mark issue affect Microsoft 365?

Based on current reports and testing, this specific glitch could not be reproduced in Microsoft 365 Excel. It appears to be limited to specific standalone versions of Office after a recent security patch.

How do I open Excel in Safe Mode to test formulas?

Press and hold the Ctrl key while clicking the Excel shortcut, or type 'excel /safe' in the Windows Run dialog (Win + R) and press Enter. This opens Excel without add-ins to rule out third-party interference.

Excel & Data Problems