Sort Data by Last Character in google sheets

Sort Data by Last Character in google sheets

If you are an avid Google Sheets user, then you may have an urgent task to rank the text value by the last character from the cells; you can do this task manually very easily, which is also feasible, but only for sorting a small list of data. However, when there are a number of lists of data to be processed, it becomes a cumbersome and time-consuming task to sort by the last character by manually.

But don’t worry, because this article will guide you how to sort the data in a given cell range by the last character in google sheets.

Sort Data by Last Character

Suppose you have a list of data in the range B1:B5 that contains text string values. You need to rank the cells based on the last character in the cell. You can easily rank the cell range by the first character by using the “Sort range” function in google sheets, but there is no function or command to sort the cell range by the last character directly in google sheets. So how can we achieve this task. You can use the helper column, and then use the RIGHT function to extract the last character of the string in the cell, and then you can sort the characters in the helper column. The following are the steps.

#1 Enter the following formula in cell C1.

=RIGHT(A1,1)

Sort Data by Last Character in google sheets1

#2 Press Enter on the keyboard, then drag the fill handle down to the other cells.

Sort Data by Last Character in google sheets1

#3 You need to continue to select the cells in the helper column, and then go to the “Data” tab, click “Sort sheet” menu and click the “Sort sheet by column B (A to Z)” submenu.

Sort Data by Last Character in google sheets1

#4 You should notice that the range of cells has been sorted by the last character. You can now delete the helper column.

Sort Data by Last Character in google sheets1Sort Data by Last Character in google sheets1

Related Functions

  • Google Sheets RIGHT function
    The Google Sheets RIGHT function returns a substring (a specified number of the characters) from a text string, starting from the rightmost character.The syntax of the RIGHT function is as below:=RIGHT(text,[num_chars])…
Related Posts

Google Sheets: Sort by Second or Third character

This article will talk about how to sort by the second or third character in a cell's string value in google sheets. You may want to sort the values of strings by the second or last character from the cells ...

Rank Data with Multiple Criteria in google sheets

If you are an enthusiastic Google Sheets user, then you may have an urgent task to rank a specified datelist based on given multiple criteria; you can easily perform this task manually, which is also feasible, but it only works ...

Rank Based on Specific Value in google sheets

This article will guide you how to sort the values in a given column based on a specific value in another column in google sheets. How to sort a range of values in google sheets by using IF function and ...

Sort Dynamic Data in google sheets

 This article will talk about how to sort the dynamic data in google sheets automatically. How to use RANK formula to sort the data of a given dynamic range in google sheets. Sort Dynamic Data suppose you have a list ...

Reverse Rank Order in google sheets

This article will talk about how to rank the given data in reverse order in google sheets. You can use Google sheets RANK function to rank the data. By default, the largest value in the data table will be ranked ...

Rank Numbers without Repetitive Ranks in google sheets

This article will guide you how to rank numbers in a range with unique ranking in google sheets. How to use the Rank function in google sheets to get a unique ranking for ranges with duplicate values. Ranking without Repetitive ...

Rank Numeric Values with Duplicate in Google Sheets

Suppose you have an urgent task of ranking a list with duplicate values, what would be the first approach you would think of? Is there a quick and easy way to do this task in Google Sheets? This article will ...

Calculate Compound Interest using FV Function in Google Sheets

This article will show you how to calculate compound interest in Google Sheets. It will help you calculate the interest you will accrue on a given amount of money. There are several ways to calculate compound interest Google Sheets. One ...

Count Attendance and Absence with Google Sheets COUNTIF

In our campus life and work life, we usually record everyone's attendance. Today we will introduce you the application of Google Sheets COUNTIF function to count the attendance. Using a week as an example, we use the following example to ...

Find the Closest Data to the Data Provided in Google Sheets

In our daily work, we may encounter such an issue that to find the closest value to a certain value. In fact, google sheets internal functions can help us solve this problem. In today’s article, we will show you how ...

Sidebar