Hi, I've followed MS instructions for alpha sorting (e.g. helper column w/
=text(e5,"###") ) to no help. I think that works only when the value in the
column begins with a number. My data can begin w/ a number or alpha character.

Here's an example of my data:
1
2
3
4
A1
A10
5
6
7
8
A11
A12
A2
A3
A4
A5
9
10
11
12
A6
A7
A8
A9
B1
B10
B11
B12
B2
B3
B4
B5
B6
B7
B8
B9


And here's how I want it sorted...

1
2
3
4
5
6
7
8
9
10
11
12
A1
A2
A3
A4
A5
A6
A7
A8
A9
A10
A11
A12
B1
B2
B3
B4
B5
B6
B7
B8
B9
B10
B11
B12

But it keeps coming out like this:
1
2
3
4
5
6
7
8
9
10
11
12
A1
A10
A11
A12
A2
A3
A4
A5
A6
A7
A8
A9
B1
B10
B11
B12
B2
B3
B4
B5
B6
B7
B8
B9

This is the second column of a three-column sort.

Suggestions?

Thanks,