Excel sort formulas

[Guest]

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.

 

[Bernard Liengme]

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