Excel - Sort columns based on character length(LEN Function)

Microsoft-Excel

Requirement

Sort columns in an Excel spreadsheet based on the character length of the column data. How?

Implementation(LEN function)

First, use the "LEN" function in Excel to calculate the character count in each cell of the column, and then sort based on character count.

Steps

Open the Excel spreadsheet.

Excel - Sort columns based on character length

Use the LEN function to count characters:

In the second column (e.g., column B), enter the following formula in the first cell (B1): 
=LEN(A1)
Excel - Sort columns based on character length

Sort based on character count.

Excel - Sort columns based on character length Microsoft Len function page

Comments

Post a Comment

Popular posts from this blog

Installing Python3.10.x Version on Mac and Set the Environment

Image
MacOS already comes with Python2.7 and Python3.8 pre-installed. For specific reasons, I needed to install Python3.10.x separately. After installing the new Python version, some modifications to the default environment settings are required. This article serves as a memo detailing how to modify the environment settings after installing Python3.10 on a Mac. Steps for Installing Python3.10.x and Modifying Environment Settings: 1. Install Python3.10.x 2. Configure environment variables for Python3.10.x Install Python3.10.x 1. Download Python Go to the Python official website's download page , find the corresponding version, and proceed with the download. For the purpose of this article, I will be downloading Python3.10.6 as an example. 2. Scroll down to the bottom of the page and look for "Looking for a specific release?" Tips: Use Ctrl+F to search for the Python version number you wish to download. 3. Navigate to the Python3.10.6 download page. 4. Doub...
Read more

Adding Specific Applications to Windows 11 Startup Apps

Customizing startup items in Windows 11 is a great way to streamline your computer's boot-up process and ensure that your most-used applications launch automatically when the system starts. Below are the straightforward steps for adding specific applications to Windows 11's startup items: Click the " Start " button, then search or scroll to find the application you want to add to the startup items. Right-click on the application, select " More ," and then choose "Open file location." This action will open the location where the shortcut for that application is stored. If you don't see the "Open file location" option, it means that the application cannot be added to the startup items. After opening the file location, press WIN+R , enter shell:startup , and then click "OK." This action will open the "Startup" folder. Copy the shortcut of the application from the folder opened in Step 2 to the ...
Read more

HTTPS(SSL) Blocks WordPress Admin Access

Image
When a WordPress blog configures an SSL certificate to enable HTTPS, there is a certain probability that the following issues may arise: Website CSS styling is disorganized Incorrect display of image URLs Unable to access the website admin dashboard You can modify the wp-config.php file to solve these issues. Here's how: 1. Go to the root directory of your WordPress site and open the wp-config.php file in an editor. 2. Find the following code snippet in the file: ** @package WordPress */ 3. Insert the following lines of code immediately after the above snippet: $_SERVER['HTTPS'] = 'on'; define('FORCE_SSL_LOGIN', true); define('FORCE_SSL_ADMIN', true); 4. After completing the above steps, visit the admin dashboard of your website. In the General Settings page, change both the "WordPress Address (URL)" and "Site Address (URL)" from http to https, and save the changes. 5. Generally, for a brand-new WordP...
Read more