Formula Errors

How to Remove FALSE Values from an Excel Word List Before Sorting in WPS Office

Emma BrownEmma Brown Nov 13, 2026 868 views

Question details

User needs to eliminate unexpected FALSE values that appear at the end of a sorted Excel word list caused by IF formulas without a false result.

How to Remove FALSE Values from an Excel Word List Before Sorting in WPS Office
Product
WPS Spreadsheets
Device & OS
not provided
Scenario
The user maintains a word list generated by formulas and sorts it alphabetically.
Observed behavior
After sorting A to Z, FALSE values appear at the end because the IF formula returns FALSE when the condition is false.
Before you start

Check the word list range and identify any IF formulas that contain only two arguments. When the condition is false, those formulas return the logical value FALSE instead of a blank cell.

Solution 1Recommended

Update IF formulas to return an empty string instead of FALSE

Use this when the word list is generated by formulas and you want the sort to ignore cells that do not meet the condition.

An IF formula such as =IF(A2="word",A2) returns FALSE whenever the logical test fails. Adding "" as the third argument makes the formula return an empty string, which keeps the sorted list clean.

1
Select the formula cell

Click the first formula cell in the word list column in WPS Spreadsheets.

2
Edit the formula

In the formula bar, add "" as the third argument: =IF(condition,value,"").

3
Apply to the remaining cells

Press Enter and fill the updated formula down through all word list cells.

4
Sort the list again

Select the word list range, click Data > Sort, choose the word column, and sort A to Z.

Update IF formulas to return an empty string instead of FALSE
FALSE values no longer appear: The affected formula cells now return blanks, so sorting keeps the word list clean.

Clean formula-generated word lists in WPS Spreadsheets

WPS Spreadsheets handles this directly: update the IF formula to return an empty string or replace the FALSE results with blanks before sorting, so alphabetical lists stay clean and readable.

  1. 1. Open the workbook in WPS Spreadsheets: Launch WPS Office and open the Excel workbook that contains the word list.
  2. 2. Select the formula cells: Click the first word list cell, then drag to select all formula cells in the list column.
  3. 3. Add the false argument: In the formula bar, enter "" as the third IF argument, for example =IF(condition,value,""), and press Enter.
  4. 4. Remove remaining FALSE values: Press Ctrl+H to open Find & Replace, type FALSE, leave Replace with blank, enable Match entire cell contents, and click Replace All.
  5. 5. Sort the cleaned list: Select the list range, click Data > Sort, choose the word column, and sort A to Z.
Prevents FALSE values from formula-based word lists before sortingWorks with .xlsx, .xls, and .csv files with Microsoft Excel format compatibilityFamiliar spreadsheet interface with formula editing and Find & Replace toolsFree and lightweight Office suite for everyday spreadsheet tasks
QA img-9

Frequently Asked Questions

Why does sorting a word list move FALSE values to the end in Excel?

FALSE is treated as a logical value. When an IF formula has no false argument, it returns FALSE. Sorting places text words first and logical values after them. Add "" as the false argument or replace FALSE with blanks.

How do I change =IF(condition,value) so it stops returning FALSE?

Edit the formula to include an empty string as the third argument: =IF(condition,value,""). In WPS Spreadsheets, select the cell and edit the formula in the formula bar.

Can I remove FALSE results without editing each formula?

Yes. Select the list range, press Ctrl+H to open Find & Replace, type FALSE in Find what, leave Replace with blank, enable Match entire cell contents, and click Replace All. This cleans the current results but does not prevent new FALSE values from formulas.

Will using "" as the false result affect sort order?

Cells with empty strings are generally treated as blank text and will not appear as FALSE. After sorting A to Z, the word list stays clean, though empty strings may still occupy cells.

Does this method work in WPS Spreadsheets?

Yes. WPS Spreadsheets uses the same IF formula syntax and Find & Replace workflow, and it supports .xlsx, .xls, and .csv files.