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

finding, sorting, but only part of a cell
 

I forgot to mention that the colum can go pass 9,000 rows.

"Debilee" wrote:

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

finding, sorting, put only part of a cell
 

Formula works just fine. And, you would like what? Result to be sorted
alphabetic? You'll need macro for that job.


"Debilee" wrote in message
...
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

finding, sorting, put only part of a cell
 

Thank yo for the reply - I would like the formula to sort, but only by "PP" &
"COL"


"Sasa Stankovic" wrote:

Formula works just fine. And, you would like what? Result to be sorted
alphabetic? You'll need macro for that job.


"Debilee" wrote in message
...
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

finding, sorting, put only part of a cell
 

Thank you for your assistance. It does work. I just did a newbie error!


"Sasa Stankovic" wrote:

Formula works just fine. And, you would like what? Result to be sorted
alphabetic? You'll need macro for that job.


"Debilee" wrote in message
...
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