LEN Function Archives

How to Remove Spaces in Excel: With Formula, VBA & Power Query

Nov 30, 2021 Excel Formulas

In Microsoft Excel, there are several effective methods available to remove all sorts of unwanted spaces. You’ll get to know all possible and ...

How to Count Specific Words in a Column in Excel (2 Methods)

Nov 28, 2021 Excel Basics

It's possible that the instance of a word in a text string repeats over and over again. And you might be curious to count the total occurrence of ...

How to Sort by Last Name in Excel (4 Methods)

Nov 1, 2021 Excel Basics

If you work with datasets in Excel, you will often need to sort these datasets by name. Sometimes. You may need to sort the dataset based on your ...

How to Sort by Last Name in Excel (4 Methods)

How to Sort Multiple Columns in Excel Independently of Each Other

Nov 2, 2021 Excel Formulas

In Microsoft Excel, there are a lot of ways to arrange text data alphabetically, dates chronologically, and numbers from smallest to largest or from ...

How to use TRIM function in Excel (7 Examples)

Nov 11, 2021 Excel Functions

Excel provides several text functions to help you perform your desired tasks easily and swiftly. Today we are going to show you how to use a text ...

How to use SUBSTITUTE function in Excel (4 Examples)

Nov 11, 2021 Excel Functions

There are several text functions in Excel to help you perform your desired tasks easily and swiftly. Today we are going to show you how to use a text ...

How to Use RIGHT Function in Excel (With 6 Easy Examples)

Nov 11, 2021 Excel Formulas

RIGHT is another popular function in MS Excel that is used to get the last character or characters in a text string, based on the specific number of ...

How to Use MID Function in Excel (3 Examples)

Nov 11, 2021 Excel Formulas

Today I will be showing how you can extract some specific number of characters starting from a specific position of a string using the MID function ...

How to use LEFT function in Excel (4 Examples)

Nov 11, 2021 Excel Functions

Excel provides several text functions to help you perform your desired tasks easily and swiftly. Today we are going to show you how to use a text ...

How to Use REPT Function in Excel (8 Suitable Examples)

Nov 11, 2021 Excel Functions

In Microsoft Excel, the REPT function is generally used to repeat a text or a character a defined number of times in a cell. In this article, you’ll ...

How to Use REPLACE Function in Excel (3 Suitable Examples)

Nov 14, 2021 Excel Functions

In Microsoft Excel, the REPLACE function is generally used to replace or substitute a text. The replacement is based on its starting position and ...

How to Use FIND Function in Excel (7 Suitable Examples)

Nov 14, 2021 Excel Functions

In Microsoft Excel, the FIND function is generally used to extract the position of a defined text in a cell containing a text string. In this ...

How to Use LEN Function in Excel (Formula and VBA Code)

Nov 14, 2021 Excel Formulas

Excel provides a function called LEN for counting letters, numbers, characters, and all spaces. LEN is a short form of LENGTH. LEN function is used ...

Excel Compare Two Cells Text (9 Examples)

Oct 17, 2021 Excel Formulas

When we do compare two cells manually, it is not an issue. But it's next too difficult to locate the variations between hundreds and thousands of ...

How to Split One Cell into Two in Excel (5 Useful Methods)

Nov 15, 2021 Advanced Excel

When you import data from a database or any other sources, you have to split cell one into two or more in such situations. In this tutorial, I’m ...