Sorting Blanks First
Hi,
I can't reproduce your results
You say you get:
FM2130
FM3126
FM4120
FM10
FM76
FM613
I get:
FM10
FM2130
FM3126
FM4120
FM613
FM76
To get a sort based on the numbers, assuming each is preceeded by to text
characters, create a dummy column with the formula:
=--MID(A2,3,10)
This assumes the entries start in A1. Copy the formula down and then sort
on this column.
--
If this helps, please click the Yes button
Cheers,
Shane Devenshire
"texasdeputy" wrote:
I have a alphanumeric list as -
FM2130
FM613
FM3126
FM10
FM76
FM4120
I need it in an order as -
FM10
FM76
FM613
FM2130
FM3126
FM4120
It gets sorted as -
FM2130
FM3126
FM4120
FM10
FM76
FM613
The problem is that blanks need to be in a sort sequence first not last. How
do I fix this for all sorts.
|