Sorting problem

[rbush]

Hi
My sorting looks something like this: 1312, 2192, 2193, 21931, 1615A, 1718B, 2193B but it needs to look like: 1312, 1615A,1718B, 2192, 2193, 2193B, 21931. The column is in text and its an inventory database. Please help. Nothing works that I do! Please help.

[Special-K]

Your incorrectly sorted column is a mixture of sorted numbers then sorted text. You need to align everything then sort.
Looks like the length of your inventory items are 5 characters maximum.
Try this

With the data in A1 use a Helper column with this formula

=LEFT(A1&" ",5)
Note 4 spaces above

Now sort on this new column and everything should sort the way you want.

[Fotis1991]

Hi

Let's say that your data, starts in A2. Then in B2, put this formula.

=LOOKUP(9^9;--LEFT(A2;COLUMN($1:$1)))

Copy down.

Then sort by column B(Hide this column if you like)

Hope to helps you.