Hi
I have a list of addresses that currently sort as follows:
1 Acacia Road
10 Acacia Road
11 Acacia Road
2 Acacia Road
21 Acacia Road
22 Acacia Road
3 Acacia Road
31 Acacia Road
etc.
How can I get them to sort in ascending order of the number i.e. 1, 2, 3, 10, 11, 21, 22, 31 etc
I have...