I'm trying to sort a substantial list of titles e.g. C1, C2, C3, C4... C10, C11, C12, C100 etc. However on sorting Excel arranges the cells C1, C10, C11, C12, C100, C2, C3, C4 (default sort order). Is there a way to sort the cells paying attention to the numeric value e.g. C1 then C2, not C1 then C100?
Kind regards.
Kind regards.