Custom Sorting
select the whole range first and sort ascending
this will give you ,,, numbers,,,,numbers with text,,,text,,,spaces
--
Greetings from New Zealand
"CathyZ" wrote in message
...
I have a column that has blanks, characters, numbers, number w/ text
attached
and text. When I sort (selecting sort with numbers and numbers stored as
text
separately) the order items are returned in is : blanks, characters,
numbers
and numbers w/ text mixed together, then text. I want to be able to sort
so
my numbers and numbers w/ text appear first. Please advise if possible.
For example:
Sorting: current sort
#
(this is a blank)
123
123A
HOME
Desired Sort:
123
123A (these two can be interchangeable)
#
HOME
(blank) (these bttm 3 can be interchangable)
TFTH
|