I have numerical data with alphabetical prefixes in a column.

This is what I get when I sort:
C1,C10,C2,C8,R1,R10,R11,R2

This is what I want when I sort:
C1,C2,C8,C10,R1,R2,R10,R11.

How can I do this?