Help with sorting numbers and letters that are combined in one cell?

lexir223

I would like to sort by a column that has both numbers and letters in a cell. Such as 1, 1a, 1b, 1c. Right now if I sort it by it by the ascending option, it's able to do 1a, 1b, and 1c correctly, however it separates it from the numbers that don't have any letters. For example:

This is what it does:

1

2

3

1a

1b

2a

2c

3b

3c

This is what I want:

1

1a

1b

2

2a

2c

3

3b

3c

Any help or suggestions? I can't figure this out. I wish there was a custom sort option like in Excel. Thanks!

Melissa Boehl

@lexir223 Honestly I do not think there is any way to get it to sort the way you are wanting it to. Sorry to be the bearer of bad news. Maybe someone else can provide you with a workaround but I have not seen this problem solved yet.