Hey guys,

I am trying to filter something here.. and I've been searching all over the internet and I can't find a solution.. Please help me! It would be greatly appreciated.

So I a list of 5000+ rows on my Excel (2003).

How do I filter a field just by its last 2 characters?

For example, on my list I have a column:

Column value:

B33581
B33581_P
B33581_L
L500030
L500030_L
T088801
T088801_P

and the list goes on...

How can I filter it so that the sheet only shoes values with _L and _P on it?

Thank you!!! Any experts please help!!!