Can't see any way to do what you'd like to do, except by creating a helper
column with a formula akin to what I offered.

Sorry

"Brian" wrote:

Thanks Duke.

I was trying to avoid that.

Wondering if there is anyway to sort data in place?


"Duke Carey" wrote in message
...
In an adjacent cell use this formula - (assuming the number is in A2)

=right(A2,2)&mid(A2,3,2)&left(A2,2)

Copy the formula down & then sort on that column


"Brian" wrote:

The data is actually all together, ie 123456. NOT 12 34 56.

Thanks.


"starguy" wrote in
message ...

I am not sure that either you have space after two digits or not.
with spaces digits would be like this 12 34 56
without spaces digits would be 123456

confirm that what type of data you have because method would be
different for both type of digits.

Brian Wrote:
Howdy All,

I have record information in a spreadsheet that contains terminal
digit
record numbers.

Terminal digit is a filing system that uses 3 sets of 2 numbers,
example 12
34 56. But the system works kind of in reverse, 56 is the first number
you
look at, then 34, then 12.

I have these record numbers in column B. I need to sort them by
terminal
digit, meaning by the last 2 numbers first, then by the middle 2, and
lastly
by the first 2.


Can someone help me out with a simple solution?

Thanks,
Brian


--
starguy
------------------------------------------------------------------------
starguy's Profile:
http://www.excelforum.com/member.php...o&userid=32434
View this thread:
http://www.excelforum.com/showthread...hreadid=570746