Sort Mixed Data With Periods, Letters, Numbers, Backslashes and Hyphens

Wow....to begin with, I'm no where near a guru with Excel...

Okay, here we go...so I have a lot of rows of data, like nearly 7,000 that I need to sort.

The way I need to sort it is from left to right. For instance:

004444-61
012-06002-301
012-06004-301
012-06005
02010999-202
02892
031118-24
10015767-054
10560G
1081-170
1473342PC79
149D1100
1SD10-P-6SM917
M13516/7−4
M62217/1−32−2.0
LC34EN2/D02
LH89/1

What I have noticed with the data I need to sort...is that the periods and backslashes only appear when there are strings that start with letters.

Help on sorting nearly 7k of rows by one column of this mixed data is greatly appreciated.

Mark

Thank you for the response.

Originally Posted by Pauleyb

Possible complexities -
You say sort 'left to right'. That is typical sort behavior (at least in the US). Or, do you mean your data is left to right all in one row?

The sorting actually needs to be the same as what I listed in my OP.

The data you list is almost sorted. Everything is good until you have the two lines that begin with M above the lines that begin with L. Is that a typo? If not, why?

I listed the data as in the way I want it sorted according to a previous submittal, which was accepted.

You mention periods and backslashes. Okay, what about them? Do you want them removed/ignored? Again, with the list you have above, just using the Sort routine will give you the same results (other than the M and L discrepancy I mentioned above).

Yes, the periods and backslashes need to be ignored, not removed.

I used the sort method, but I get the following, which doesn't match what was previously submitted and accepted.

2892
004444-61
012-06002-301
012-06004-301
012-06005
02010999-202
031118-24
10015767-054
10560G
1081-170
1473342PC79
149D1100
1SD10-P-6SM917
LC34EN2/D02
M13516/7−4
M62217/1−32−2.0

Again, appreciate all help on this.

-Mark

The data would need to flow like this as well when dealing with letters:

DHOF−3
DNL0060
EC18
F02B125V5A
FFW100
FMP32A100E
L490725−59
LC34EN2/D02
LC35GT2

Originally Posted by oeldere

officemate,

show it in a file, and add the expected result also in your file, which you post on the forum.

I can't figure out how to upload a file here....or it may just be that I don't have access to do that.