Slightly fewer steps: (if you mean the digits after the six and before the
/)

Edit|Replace
what / (right slash)
with , (comma)

Select the column with the copy of your original and do
Data=>Text to columns

select delimited

select comma and other
in the other box, put a period (.)

sort on the on the center column.

--
Regards,
Tom Ogilvy

"Dave Peterson" <petersod@verizonXSPAM.net> wrote in message
news:43130A4B.8A8D8441@verizonXSPAM.net...
> I would use a few helper columns.
>
> I'd copy the original column to another column.
>
> Then select that column and do
> edit|replace
> what: : (colon)
> with: | (vertical bar)
> replace all
>
> followed by
> edit|replace
> what: . (dot)
> with: | (vertical bar)
> replace all
>
> followed by
> edit|replace
> what: / (slash)
> with: | (vertical bar)
> replace all
>
> Then insert 4 more columns to the right of that helper column
>
> Then with that helper column still selected, I'd do
> data|text to columns
> delimited by |
>
> Now all the values are in their own column.
>
> Select the whole range and sort by the column that you want.
>
>
> howard11 wrote:
> >
> > Does any one know how to get Excel to sort a column such as this:
> >
> > O:6.1/0
> > O:6.1/1
> > O:6.1/10
> > O:6.1/11
> > O:6.1/12
> > O:6.1/13
> > O:6.1/14
> > O:6.1/15
> > O:6.1/2
> > O:6.1/3
> > O:6.1/4
> > O:6.1/5
> > O:6.1/6
> > O:6.1/7
> > O:6.1/8
> > O:6.1/9
> > O:6.11/0
> > O:6.11/1
> > O:6.11/2
> > O:6.11/5
> > O:6.11/6
> > O:6.12
> > O:6.2/0
> > O:6.2/1
> > O:6.2/2
> > O:6.2/3
> > O:6.2/4
> > O:6.2/5
> > O:6.2/6
> > O:6.2/7
> > O:6.7/0
> > O:6.7/2
> >
> > in numerical order by the digit after the 6? I've been playing with
> > this for a week and its driving me crazy.
> >
> > --
> > howard11
> > ------------------------------------------------------------------------
> > howard11's Profile:
http://www.excelforum.com/member.php...o&userid=26750
> > View this thread:
http://www.excelforum.com/showthread...hreadid=400038
>
> --
>
> Dave Peterson