LEN Function Archives

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

May 11, 2023

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 ...

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

Excel If Cell Begins with Certain Text Then Return Value

May 11, 2023

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 ...

Excel If Cell Begins with Certain Text Then Return Value

How to Calculate Deviation in Excel (3 Easy Examples)

Mar 6, 2023

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 Calculate Deviation in Excel (3 Easy Examples)

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

May 18, 2023 2

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 Alphabet in Excel Sheet (5 Easy Methods)

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

Jan 3, 2023

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 Specific Words in Excel (3 Effective Ways)

How to Count Words in Excel (6 Easy Methods)

May 18, 2023

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 Count Words in Excel (6 Easy Methods)

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

Feb 28, 2023

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 Create Permutation Table in Excel (4 Easy Methods)

How to Calculate Permutations Without Repetition in Excel

Feb 19, 2023

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 Calculate Permutations Without Repetition in Excel

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

Apr 30, 2023

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 from Left in Excel (5 Suitable Ways)

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

Jan 2, 2023

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 Truncate Text After Character in Excel (4 Suitable Ways)

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

Feb 27, 2023

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 Perform Pattern Matching in Excel (2 Suitable Methods)

How to Truncate Numbers in Excel (8 Suitable Methods)

Feb 7, 2023

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 Truncate Numbers in Excel (8 Suitable Methods)

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

Jan 1, 2023

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 Find All Combinations of 1 Column in Excel (2 Handy Ways)

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

Mar 29, 2023

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 Convert Decimal Number to Hexadecimal (Hex) in Excel

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

Dec 29, 2022

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 ...