Sort with words

[Manolocs]

Hello, I am trying to sort a column with data like this: ans-1 ~ ans-10500 but when I sort is not in sequence.
How can I make it sorted in numbering sequence.
Thanks in advance

[TABLE="class: grid, width: 200, align: left"]
<tbody>[TR]
[TD]ans-1[/TD]
[TD]john[/TD]
[/TR]
[TR]
[TD]ans-10[/TD]
[TD]Edward[/TD]
[/TR]
[TR]
[TD]ans-1000[/TD]
[TD]mike[/TD]
[/TR]
[TR]
[TD]ans-1001[/TD]
[TD]dool[/TD]
[/TR]
[TR]
[TD]ans-1002[/TD]
[TD]roger[/TD]
[/TR]
</tbody>[/TABLE]

 

[BarryL]

you could put a helper column in beside it and sort using that column.

=MID(A1,SEARCH("-",A1)+1,256)

 

[Manolocs]

Hi BarryL, I am doing this only with numbers in another column.... I was wondering if could sort in that index thanks for your time....