Best way to sort

[Roldy]

just create two more columns and split your W6x15 description. one column would contain 6 and the other 15.
then sort on to this two columns.

to convert to numbers, respectively:

first colum:

=VALUE(LEFT(SUBSTITUTE(A2,"W",""),FIND("x",SUBSTITUTE(A2,"W",""))-1))

second column:

=VALUE(MID(A2,FIND("x",A2)+1,99))

I failed to mention that I need to do this programmatically due to the program environment I'm in. I am not using Excel. I'm using VBA within another program. I couldn't find a strictly VBA sub forum to put this question in.