Hello,
I have a sheet of data I need sorted according to a value in a column
(C), which is both text and numeric. You can see below that the C
column doesn't sort the rows correctly as BG 10 should be after BC9

A B C

18 3:46 AR 7
19 4:24 AR 8
20 5:05 AR 9
21 2:49 BG 1
22 5:41 BG 10
23 3:08 BG 2
24 3:28 BG 3

The C column data always has two letters before the number (i can make
it with or without the space before the number) I don't really want
to have to use another column to store any values as it is already an
overly complicated spreadsheet.
Please could anyone help me with this? All reply's appreciated!
Shorty