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!!!
Bookmarks