Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
how to input a 12 digit number into a cell | New Users to Excel | |||
How do i save a 12 digit number in a .csv document in excell? | Excel Discussion (Misc queries) | |||
Display a 16 digit number | Excel Discussion (Misc queries) | |||
Letters and 000s in front of actual number not sorting correctly | Excel Discussion (Misc queries) | |||
When we enter a 16 digit number (credit card) the last digit chan. | Excel Discussion (Misc queries) |