Excel REPT Function – Repeat Text Multiple Times in Cell

Many a time, while working in excel you may find a necessity to repeat a particular text string, number, or symbol for a particular number of times in a cell. One way is to manually type that text string in the cell. However, excel has come up with a function called the REPT excel formula which makes this task very quickly.

In this blog, we would unlock how to use the REPT function in Excel to repeat text in cell quickly.

Here we 😎

Read moreExcel REPT Function – Repeat Text Multiple Times in Cell

Excel UPPER Function – Convert Letters In Upper Case

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

Excel LOWER Function – Convert Letters In Lower 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

LEN Function in Excel – Find Number of Characters

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

MID Function in Excel – Extract Text From Middle

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

Excel RIGHT Function – Extract Text from Right Side

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

Excel LEFT Function – Extract Text from Left 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

Excel FIND Function – Get Position of Text in String

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

Excel TEXTJOIN Function – Join Text with Delimiter

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