Data sort
 

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 datasortaccendingok, 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?

Data sort
 

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
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"JK" wrote in message
...
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 datasortaccendingok, 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?