Just do a normal sort, numbers sort before text.
--
Jim Cone
San Francisco, USA
http://www.officeletter.com/blink/specialsort.html


"jfcby"
wrote in message
Hello,
I have a workbook with 75 worksheets 3 Columns and rows varies from 2
to 500. In column C my data looks like this:
1
1A
5B
15C
G-01
G-02
MC02
100CE
101CO
101CO
106CE
106CE
BOILER
CO103
CO108
MECH2
MECH
MECH
220CE
221C
203
226
CO214
300A
301C

Since I'm tring to sort Column C so that my numbers will be in numeric
order I need to move the letters with numbers into Column D which is
empty.
My questions is: How do I move the letters on the left or right side of
a number in column C to column D?
I've searched for a maro code to do this but I've been unsuccessful.
Thank you for your help,
jfcby