| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
finding, sorting, put only part of a cell
Hello Everyone,
I hope you can help me with this. I have a report from SAP in Text format. One column needs to be sort buy 2 or 3 letters with in the discription the cell. I have this formula =+IF(ISERROR(FIND("COL",M2)), "PP","COL") I get a result but not a sort. example of what is inside the cell: U:01: U-FedEx Ground (PP) 5d U:01: U-FedEx Std (COL) 1d U:73: U-UPS Blue (COL) 2d U:MX: U-FedEx SPAN Def (PP) 3d thanks Debbie |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Finding a Maximum amount of a part of the data | Excel Discussion (Misc queries) | |||
| Finding Merged Cells (Part 2) - Free 58k macro | Excel Discussion (Misc queries) | |||
| Finding specific text in string - Part II | Excel Worksheet Functions | |||
| Sorting Alpha Numeric Part 2 | Excel Discussion (Misc queries) | |||
| finding part of fole path | Excel Worksheet Functions | |||
Threaded Mode
