LEN Function

How to Use SUMIF Function to Sum Not Blank Cells in Excel

Summing is one of the most performed operations in Excel. In Excel, there are multiple functions that you can use to sum values. Among these, the ...

Excel If Cell Begins with Certain Text Then Return Value

While working on a large dataset sometimes you need to check certain values that begin with specific data. In case you work on a smaller dataset ...

How to Calculate Deviation in Excel (3 Easy Examples)

In this article, I will show you how to calculate standard deviation in Excel. In many situations, we need to calculate standard deviation whether ...

How to Count Alphabet in Excel Sheet (5 Easy Methods)

Whenever you work with a dataset that contains some sentences or words, you may need to count the alphabet in the Excel sheet. Excel shines here, ...

How to Count Specific Words in Excel (3 Effective Ways)

Microsoft Excel is a powerful software that uses Excel functions to count almost anything. Unfortunately, Excel doesn't come with a built-in feature ...

How to Count Words in Excel (6 Easy Methods)

In this article, I will show you how to count words in Excel. While working in Excel, we may want to calculate the total number of words in a cell or ...

How to Create Permutation Table in Excel (4 Easy Methods)

This tutorial will demonstrate how to determine Excel permutation table. We use the Permutation in Excel where in the data the order of the data ...

How to Calculate Permutations Without Repetition in Excel

Permutation is such a great mathematical concept that has a significant impact on every aspect of education. We can see its usage in math, quantum ...

How to Truncate Text from Left in Excel (5 Suitable Ways)

When you have a big dataset with text as cell values, then you may need to shorten the text in Excel. Basically, you can truncate a text either from ...

How to Truncate Text After Character in Excel (4 Suitable Ways)

In this article, we will learn how to truncate text after a character in Excel. Sometimes we need to truncate any cell information dependent on ...

How to Perform Pattern Matching in Excel (2 Suitable Methods)

Excel is the most widely used tool for dealing with massive datasets. We can perform myriads of tasks of multiple dimensions in Excel. In Excel, we ...

How to Truncate Numbers in Excel (8 Suitable Methods)

Truncating a number means decreasing the number of digits from the decimal section or from the right side of that number in mathematics. In Excel, ...

How to Find All Combinations of 1 Column in Excel (2 Handy Ways)

In mathematics, calculating combinations of a certain number of characters is a very common practice. In fact, we can count these combinations in ...

How to Convert Decimal Number to Hexadecimal (Hex) in Excel

The article will focus on some key aspects of how to convert decimal numbers to hexadecimal format (hex) in Excel. There are many technical ...

How to Use REGEX without VBA in Excel (with Easy Steps)

If you are using REGEX without VBA in Excel, this article may help you in this regard. REGEX is the abbreviated form of the term "regular ...

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo