How to Remove FALSE Values from an Excel Word List Before Sorting in WPS Office
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.

- 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.
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.
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.
Click the first formula cell in the word list column in WPS Spreadsheets.
In the formula bar, add "" as the third argument: =IF(condition,value,"").
Press Enter and fill the updated formula down through all word list cells.
Select the word list range, click Data > Sort, choose the word column, and sort A to Z.

Replace existing FALSE results with blanks before sorting
Use this when you prefer not to edit formulas and only need to clean the current FALSE values before sorting.
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. Open the workbook in WPS Spreadsheets: Launch WPS Office and open the Excel workbook that contains the word list.
- 2. Select the formula cells: Click the first word list cell, then drag to select all formula cells in the list column.
- 3. Add the false argument: In the formula bar, enter "" as the third IF argument, for example =IF(condition,value,""), and press Enter.
- 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. Sort the cleaned list: Select the list range, click Data > Sort, choose the word column, and sort A to Z.

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.




