Question

Write a short note on removing the information in the cell

Answer 1

Answer:

The RIGHT function can be used to create a substring consisting of one or more characters from the right end of a string. So you can add a column and put the formula =RIGHT(A1,1) in the first cell in order to get the last character from cell A1. Then use Fill Down so Excel adjusts the A1 reference for all the other rows. The resulting column can then be filtered using autofilters so you can easily see which rows have an "a" suffix. The AutoFilter drop list will contain all the suffix letters -- just deselect them all and then select "a"

You could also use the =IF() function to test the result for equality with "a" and then return different results depending on whether it's equal or not equal. For example, "Ends in a" and "Doesn't end in a".

Combined, the two functions would look like this:

=IF(RIGHT(A1,1)="a","Ends in a","Doesn't end in a")