Functions

Many a time, you may want to convert the characters/letters in a sentence into upper case (i.e. capital letters) in Excel. Changing the entire sentence by again typing the entire sentence into capital letters may feel boring and tiresome. To help you with this task quickly, excel has come up with a formula called the UPPER Function in Excel.

In this blog, we would cover everything about how to use the UPPER excel formula with examples.

Here we go 😎

Read moreExcel UPPER Function – Convert Letters In Upper Case

Many a time, a need may arise to quickly convert a sentence in lower or upper or mix case into a proper format. To achieve this, excel has provided with an inbuilt function called the PROPER Excel Function.

In this tutorial we would learn how to use the PROPER formula in Excel, along with examples.

Let us begin!! Here we go 😎

Read moreExcel PROPER Function – Convert Into Sentence Case

Many a time, while working with texts in excel, you may get the sentence in capital letters or not in a proper case. In that case, you may want to convert the characters/letters in a sentence into lower case (i.e. non-capital). This is very easy to achieve in excel by using the LOWER excel function.

Let us deep-dive into how to use the LOWER formula in excel.

At the end of this blog, I would also show you how did I practically use the LOWER excel formula to achieve my excel task.

Here we go 😎

Read moreExcel LOWER Function – Convert Letters In Lower Case

Many a time, while working in excel an excel user may face a challenge about how to calculate or count the total number of characters/letters in a particular cell or text in excel. This challenge is easy to overcome if you know how to use the LEN Function in excel.

In this tutorial, we would learn about the LEN formula in excel, its syntax, arguments with examples.

Here we go 😎

When to Use LEN Function in Excel

The Excel LEN function is used to find the total number of characters in a particular text or string cell. In other words, it is a useful function to calculate the total length of a text string or a cell.

Read moreLEN Function in Excel – Find Number of Characters

In our previous blogs, we had learned about how to use the excel LEFT formula to extract a specific number of characters from the beginning (i.e. from left). Similarly, the RIGHT function extracts specific characters from the end of the text (i.e. from the right). In this tutorial, we would learn about another such important function called the MID function in excel.

Akin to the above two functions, the MID formula in excel is also a useful function to extract a particular string from another text. However, unlike the above two formulas, the MID function extracts strings from between the text.

Let’s deep dive into this function and learn about how to use the MID function in Excel.

Here we go 😎

Read moreMID Function in Excel – Extract Text From Middle

In a previous blog, we had learned how to extract the text from the left of a string with the help of excel’s LEFT function. Likewise, the RIGHT function in excel is used to extract a certain number of characters from the right of a string or text.

In this article, we would unlock everything about the Excel RIGHT function along with simple to advanced examples.

Here we go 😎

Read moreExcel RIGHT Function – Extract Text from Right Side

This blog covers one of the most used formulas in Excel viz. the excel LEFT function. The LEFT function, as the name itself suggests, is used to extract a certain number of characters from the beginning or start of a text in excel.

This tutorial covers purpose of LEFT function, its syntax, arguments, and how to use LEFT function in excel with the help of examples.

Let’s begin. Here we go 😎

Read moreExcel LEFT Function – Extract Text from Left Side

In our previous blog, we learned about the FIND function in excel which finds the position of a string. The SEARCH excel function is exactly akin to the FIND function with a small difference.

In this tutorial, we would learn how to use the SEARCH formula in excel to search for the position of a particular string or text in another text or cell.

Here we go 😎

Read moreSEARCH Function in Excel – Search String in Excel

In one of our previous blogs, we had learned how to use the Find and Replace dialog box in excel to find a cell containing a particular string and/or replace its value. Sometimes you may have a need to find the position of a particular text/string in another string in a particular cell. To achieve this, there are two inbuilt functions provided in Microsoft excel. They are the FIND function and the SEARCH function in excel.

In this tutorial, we would unlock how to use the FIND formula in excel along with examples.

Here we go 😎

Read moreExcel FIND Function – Get Position of Text in String

Many a time, while working with text and values in excel, one may have to check if two values or text are equal or not. The EXACT excel function is a very useful formula to compare two values or text in excel.

In this tutorial, we would learn how to use the EXACT function in excel, its syntax, arguments and examples.

Here we go 😎

Read moreEXACT Function in Excel – Match Two Values

The TEXTJOIN Function in Excel is a newly introduced formula that is available in Excel 2019 and Office 365 versions of excel. It is also available in excel’s online version.

Similar to the CONCATENATE and CONCAT functions, the TEXTJOIN formula in excel allows you to join 2 or more texts, numbers, strings, values in excel cell or cell range.

However, unlike the other two functions, the TEXTJOIN Excel function joins and concatenates values with delimiters.

Let us deep dive in to how to use the Excel TEXTJOIN Formula 😎

Read moreExcel TEXTJOIN Function – Join Text with Delimiter