Data sort

[JK]

How do I sort data in accending order when the data has text first and then
numbers seperated by a dash such as; boy-1, boy-2, boy-3.....boy-10? If I
use data>sort>accending>ok, it puts it in order like; boy-1, boy-10, boy-2,
boy-3. Is there a way to make it sort so it does not put boy-10 after boy-1
and instead puts it after boy-9 like I want?

 

[Bernard Liengme]

You will need to use a helper column.
If the text is in column A, use the formula =--MID(A1,5,255) in row of some
empty column (maybe one newly created with Column | Insert). Copy down the
column, sort all the range using the 'new' column as the key.
best wishes