select all new columns and copy them, then right click on your selection
(don't deselect the columns) and click past special, click past
values
your formulas are changed to the values they return. now you can sort
these columns as per your preferences.

Joker Wrote:
Thank you for the reply, however, when I try to sort that new column, it
will
not do anything. If I manually type the same numbers in, it will sort
them.
Any suggestions?

"Ardus Petus" wrote:

Create a helper column with formula (say original data is in A1):
=LEFT(A1,2)&MID(A1,4,255)
Sort by that new column

HTH
--
AP

"Joker" a écrit dans le message de
news:
...
Hi I am having trouble trying to sort a group of numbers with
letters.
Below
are some examples of what I am trying to sort and in the correct
order.
The
first number represents the floor the groups are on 1, 2, or 3.
Second, is
the section within that floor. So "A" would be at the front of the
floor,
"B"
is the section behind it, so on and so forth. The third letter is
insignificant and should not factor into the sorting. The next two
numbers
represent the group within the section and the last two numbers
represent
the
item within the group. So... 1AW0601 would be on the first floor
(1)
section
"A" (A) the 6th group (06) and the first item (01). I know this is
very
confusing. Any help getting these sorted would be greatly
appreciated.
Thanks

1AW0601
1AW0804
2CC0401
2DF0402
3BB0406
3BW1201






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