| 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) | |||
Hybrid Mode
