I have an end user that is looking to have an excel spread sheet sort a
series of #'s with same parent # but with suffixes
IE; 408237
408237A
408237B
408238
408238A
408238B
or
408237
408237.1
408237.2
408238
408238.1
408238.2
ETC.... She's looking to have this done automatically if possible if not
auto then a simple solution for additional end users who are novice at best.

--
Michael Coble
Rosendin Electric Inc
Network Administrator
Desktop Support

It is possible using helper columns.
If the first entry is in A1, then in B1 use =LEFT(A1:A6,6)
and in C1 use =IF(LEN(A1)=6," ",RIGHT(A1:A6,1))
Now sort A1:C10000000 using Column B as first key and Column C as second key
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"Michael" wrote in message
...
I have an end user that is looking to have an excel spread sheet sort a
series of #'s with same parent # but with suffixes
IE; 408237
408237A
408237B
408238
408238A
408238B
or
408237
408237.1
408237.2
408238
408238.1
408238.2
ETC.... She's looking to have this done automatically if possible if not
auto then a simple solution for additional end users who are novice at
best.

--
Michael Coble
Rosendin Electric Inc
Network Administrator
Desktop Support