Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
sorting part numbers
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 -- Mike Fitz |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
sorting part numbers
=RIGHT(A2) in a helper column, and autofilter
-- David Biddulph "fitzsociety" wrote in message ... 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 -- Mike Fitz |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
sorting part numbers
DataFilterAutofilterCustom "ends with"
Gord Dibben MS Excel MVP On Thu, 26 Jun 2008 09:47:00 -0700, fitzsociety wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
finding, sorting, put only part of a cell | Excel Worksheet Functions | |||
Count Part Numbers | Excel Discussion (Misc queries) | |||
Sorting a column from the last letter or 2 letters of a part numbe | Excel Discussion (Misc queries) | |||
Replace Old Part Numbers with New Part Numbers in a Macro. | Excel Discussion (Misc queries) | |||
Sorting Alpha Numeric Part 2 | Excel Discussion (Misc queries) |