I want to sort, ignoring all characters except numbers

Here are more examples that would need sorting, properly.

6PHY
(6
6)
6CHE
6OT

Of course, there will be different numbers associated with each of the
'non-number' characters. I think this is just about it.

Thanks, Jo

RagDyer wrote:
> You can use a "helper" column to extract the numbers with a text formula,
> and then select the original *and* the "helper" column, and sort on the
> "helper" column.
> Then you can delete the helper.
>
> This will extract the numbers from the type of data that you posted in your
> example:
>
> =--SUBSTITUTE(SUBSTITUTE(A1,"[",""),"]","")
>
> If you example *didn't* show all the characters in your data, post back with
> all possibilities, or at least a more extensive illustration.
>
> --
> HTH,
>
> RD
> ==============================================
> Please keep all correspondence within the Group, so all may benefit!
> ==============================================
>
>
> "wojo" <[email protected]> wrote in message
> news:[email protected]...
> > I have a need to sort, a column, with cells that contain both
> > letters/characters and numbers. When the cell has a combination of
> > characters and numbers, I would like Excel to ignor any character that
> > is NOT a number and then sort the cells.
> >
> > Example of data
> >
> > 6
> > [6
> > 6]
> > [6]
> > 7
> > 12
> > 14
> > 14]
> >
> > The above example 'shows' the resulting sort that I am looking for. I
> > need to keep the data displayed with the extra characters.
> >
> > Any help out there?
> >

Do you have square brackets *in addition* to parenthesis, or was the
original post a typo?

This is for what you posted as your latest example (no square brackets):

=--SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A1,"(",""),")","")
,"PHY",""),"CHE",""),"OT","")
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

"wojo" <[email protected]> wrote in message
news:[email protected]...
Here are more examples that would need sorting, properly.

6PHY
(6
6)
6CHE
6OT

Of course, there will be different numbers associated with each of the
'non-number' characters. I think this is just about it.

Thanks, Jo

RagDyer wrote:
> You can use a "helper" column to extract the numbers with a text formula,
> and then select the original *and* the "helper" column, and sort on the
> "helper" column.
> Then you can delete the helper.
>
> This will extract the numbers from the type of data that you posted in
your
> example:
>
> =--SUBSTITUTE(SUBSTITUTE(A1,"[",""),"]","")
>
> If you example *didn't* show all the characters in your data, post back
with
> all possibilities, or at least a more extensive illustration.
>
> --
> HTH,
>
> RD
> ==============================================
> Please keep all correspondence within the Group, so all may benefit!
> ==============================================
>
>
> "wojo" <[email protected]> wrote in message
> news:[email protected]...
> > I have a need to sort, a column, with cells that contain both
> > letters/characters and numbers. When the cell has a combination of
> > characters and numbers, I would like Excel to ignor any character that
> > is NOT a number and then sort the cells.
> >
> > Example of data
> >
> > 6
> > [6
> > 6]
> > [6]
> > 7
> > 12
> > 14
> > 14]
> >
> > The above example 'shows' the resulting sort that I am looking for. I
> > need to keep the data displayed with the extra characters.
> >
> > Any help out there?
> >

Yes, I use both brackets and parenthesis. But, I am getting the idea.
When I have time to give it a try, I will respond here.

thanks in advance, JO