Custom Formatting Problem

Posted by Daniel Cash on December 27, 2000 7:41 PM

I need to format my column:
6694
8185
5314 01
5314 02
5314 03
6071 01A
6071 02A
6169C
6180C
6170

to order in the following way:
5314 01
5314 02
5314 03
6071 01A
6071 02A
6169C
6170
6180C
6694
8185
or to recognize only the first four digits for sorting in decending order. Thanks.

Posted by Dave on December 27, 2000 9:08 PM

Hi Daniel

Lets say your numbers are in Column B. In Cell A1 put: =Left(B1,4) then double click the fill handle to copy them down.

Now simply sort Column A:B by Column A. Then delete column A.

Dave

OzGrid Business Applications