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

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:

This is what I want:

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

Find more posts tagged with

Sheets

Formulas

Support

Solution Center

Conditional Formatting

Accepted answers

All comments

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.

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.