I have a single column, each cell beginning with 'RG-' and followed by a three or four digit number followed by '.jpg'. For example:
RG-9002.jpg
RG-2005.jpg
RG-201.jpg
RG-908.jpg
RG-550.jpg
RG-2009.jpg
RG-2548.jpg
I want to sort the column low to high, based on numerical value. The sort ascending function places the above cells into the order shown below.
RG-2005.jpg
RG-2009.jpg
RG-201.jpg
RG-2548.jpg
RG-550.jpg
RG-9002.jpg
RG-908.jpg
I need it to sort in numerical order, like this:
RG-201.jpg
RG-550.jpg
RG-908.jpg
RG-2005.jpg
RG-2009.jpg
RG-2548.jpg
RG-9002.jpg
Any help is much appreciated.
RG-9002.jpg
RG-2005.jpg
RG-201.jpg
RG-908.jpg
RG-550.jpg
RG-2009.jpg
RG-2548.jpg
I want to sort the column low to high, based on numerical value. The sort ascending function places the above cells into the order shown below.
RG-2005.jpg
RG-2009.jpg
RG-201.jpg
RG-2548.jpg
RG-550.jpg
RG-9002.jpg
RG-908.jpg
I need it to sort in numerical order, like this:
RG-201.jpg
RG-550.jpg
RG-908.jpg
RG-2005.jpg
RG-2009.jpg
RG-2548.jpg
RG-9002.jpg
Any help is much appreciated.