Answer by
bleo (41)

Assuming spaces separate words then copy the following formula into a column and cell adjacent to the sorting cell: =MID(SUBSTITUTE(A2," ","^",LEN(A2)-LEN(SUBSTITUTE(A2," ",""))),FIND("^",SUBSTITUTE(A2," ","^",LEN(A2)-LEN(SUBSTITUTE(A2," ",""))))+1,256). Copy and paste the values of this column and thensort on this column.