How to remove comments only from filtered cells in Excel

Consider a column which has number one to five. Cell with odd number has a comment "ODD" and even number as "EVEN".

If you have to delete comments only from even number then, 

- Filter the even numbers in column (i.e. 2 and 4)

- Then, hit the keystroke (Alt + :) this will highlight only the filtered cells

- Then, right click and delete comment from the selected cells in context menu

To apply formats for filtered cells, select all filtered cells and use comments in paste special option to paste only the comments as shown below.

.