# sorting alpha-numeric data

#### dbell

##### New Member
Hello all my 1st post.

I'm not the brightest one out there so I need help. I want ot sort this data in columb C;

RES,0 Ohm,1/8W,5%,1206
RES,0 Ohm,1/8W,5%,1206
RES,1 Ohm,1/10W,5%,0805
RES,1 Ohm,1/8W,1%,1206,MF
RES,1.2K,1/10W,5%,0805
RES,1.2K,1/8W,5%,1206
RES,1.37K,1/8W,1%,1206
RES,1.3M,1/10W,1%,0805
RES,1.40K,1/8W,1%,1206,MF
RES,10 Ohm,1/8W,5%,1206
RES,10 Ohm,1W,5%,2512
RES,10.2K,.1/8W,1%,1206
RES,10.5K,1/8W,1%,1206
RES,10.7K,1/8W,1%,1206
RES,100 Ohm,1/10W,1%,0805
RES,330 Ohm,1/10W,1%,0805
RES,100K,1/8W,5%,1206
RES,100K,1W,5%,2512
RES,102K,1/10W,1%,0805
RES,105 Ohm,1/10W,1%,0805
RES,10K,1/10W,.1%,0805
RES,10M,1/10W,1%,0805

I just want to sort by the 1st numeric value in accending order with the output like this;

RES,0 Ohm,****
RES,10 Ohm,***
RES,105 Ohm,***
RES,1K,***
RES,2.5K,***
RES,1M,***

How wouls I get this? Hope this is enough information.

### Excel Facts

Control Word Wrap
Press Alt+Enter to move to a new row in a cell. Lets you control where the words wrap.
Please elaborate a little more for me anyway

...when you say the first numberic value, the outcome is 0, 10, 105, 1, 2.5, and 1.

Are the K = thousasnds?
M=millions?

How to sort?

pll
This message was edited by plettieri on 2002-10-17 08:49

[No message]

The K values are thousands and the M values are millions. I would like to sort this data in a numeric order starting at 0 and ending at ###M. The info after the 1st numeric value is not as inportant as the 1st value.

Thanks, D

Replies
9
Views
537
Replies
11
Views
1K
Replies
2
Views
547

1,217,677
Messages
6,137,936
Members
450,099
Latest member
Pushbutton

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back