Sorting other than a-z

[Katieg]

I am doing the entries for a sporting event and have completed the entries,
but now need to sort them in to the order they will compete but do not wish
to sort in alpha order. I have three columns of info i.e. rider, horse, club
so I need to keep the information in the rows together. Can I sort by the
second letter in a name?

 

[Gordon]

I am doing the entries for a sporting event and have completed the entries,
but now need to sort them in to the order they will compete but do not
wish
to sort in alpha order. I have three columns of info i.e. rider, horse,
club
so I need to keep the information in the rows together. Can I sort by the
second letter in a name?

Use a hidden column with the order of competing in.....