Excel programming Regex?

This is a little crude but it should work. Can you create another column that would contain only the last letter of your part number (say it's in column A), using =RIGHT(A1,1), then filter the new column for "B"?