Hello All Guru's,
I have a list of race car numbers in Column A, Names in B, other stats in C & D. Below is a small sample. I have about 40 lists with 30~100 numbers in each list. I am always sorting by name, and some of the other stats. I can't figure out how to sort by car "number".
Sample Data:
20X
3J
72
48S
1W
10
4M
66L
71
91
81
92
34
7L
O2
67M
5C
17
15
TA2
8G
62C
9H
17X
37
8K
65
9
29
2V
Desired result AFTER sort:
1W
2V
3J
4M
5C
7L
8G
8K
9
9H
10
15
17
17X
20X
29
34
37
48S
62C
65
66L
67M
71
72
81
91
92
O2
TA2
Anyone have any ideas here