BOM management in excel

[Faringdon]

Hi,
I am trying to put

C1
C35
C3
C100
etc, etc

into numerical order.

So first i need to split the text "C" from the cell, so just the number is there.

Do you know how to do this?. Googling reveals that this isn't a common operation for excel'ers.

OK..to separate the C away, it seems its best to start another pllel column. then go MID(D2,2,4)......(D2 is the cell) and that seems to do it, but doesnt seem intuitive.
Ensuring that the colum with the formula, is formatted as a "general" type....(not a "text" type)

You'd think there would be an "unconcatenate" function?

[meshtron]

A bit cleaner than "MID" is this:

- Put your values in column A
- Put a formula in column B that is =TEXTAFTER(A2,"C")

Then grab both columns, and sort by Column B.