sorting part numbers

[fitzsociety]

I have a ascending list of part numbers that has randomly throughout it a
part number with a "P" at the end of it. I am trying to grab out of this list
only the "P" part numbers. The part numbers are in column A, the description
of the part number is in column B, I am trying to seperate these part numbers
from the rest witout have to go through all of them. I would like the
description to also join the part number through the seperation. Please help

 

[David Biddulph]

=RIGHT(A2) in a helper column, and autofilter

 

[Gord Dibben]

Data>Filter>Autofilter>Custom "ends with"


Gord Dibben MS Excel MVP