6. Click the plus sign beside 2017, 2016, and 2015, then uncheck March, April, and May. Then uncheck Blanks and click OK. 7. Excel displays all records not equal to (Does Not Equal) March, April ...

To remove spaces between characters and numbers in the above example, we may use the Find and Replace feature in Excel as follows: Select the data range. Click on the Find & Select dropdown in the ...