UPPER Function

How to Change Lowercase to Uppercase in Excel (6 Methods)

In this article, we’re going to show you 6 methods of how to change lowercase to uppercase in Excel. For this, we have a dataset containing 2 ...

How to Convert Number to Text without Scientific Notation in Excel

Once you input any data for example a number, it will be stored typically as a number. More importantly, if the number of digits is greater than 15, ...

How to Format Text to Capitalize First Letter in Excel (10 Ways)

Sometimes there is data in the Excel worksheet where the letter case is wrong or not in the format that you want. In this article, we will show you ...

How to Convert Exponential Value to Exact Number in Excel (7 Methods)

In this tutorial, I will show you how to convert an exponential value to an exact number in excel. Usually, when you enter a number that is longer ...

How to Convert Scientific Notation to Number in Excel (7 Methods)

In Microsoft Excel, there could be cases where we need to change the Scientific Notation to Text format to show the number in full length. One of the ...

How to Use CODE Function in Excel (5 Examples)

The CODE function, an Excel Text function returns a numeric code for the first character of a text string. The returned numeric code is based on the ...

How to Use Excel EXACT Function (6 Suitable Examples)

The Excel EXACT function tests two text strings and returns TRUE or FALSE depending on their exact match or otherwise respectively. The EXACT ...

How to Remove Scientific Notation in Excel (4 Quick Ways)

In Microsoft Excel, large and small numbers are stored automatically into Scientific Notation by default. Excel has a number limit which is 15 ...

3 Methods to Convert Scientific Notation to Text in Excel

In Microsoft Excel, there could be cases where we need to change the Scientific Notation to Text format to show the number in full length. One of the ...

Excel Count Occurrences of Character in String

In this tutorial, we will discuss the count of occurrences of a character or a word in a particular string and string range in Excel. Often, we have ...

Excel Count Specific Characters in Cell (4 Quick Ways)

Sometimes we need to count only the specific characters in an Excel cell. Different excel functions make this easy for us. In the article, we are ...

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

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

Count the Number of Specific Characters in a Cell in Excel (2 Approaches)

While dealing with MS Excel you might need to count the number of specific characters in a cell in Excel. There are several techniques to perform ...

How to Use UPPER Function in Excel (4 Examples)

In Microsoft Excel, the UPPER function is generally used to convert all the letters in a string of text to block ones. In this article, you’ll get to ...

How to Find Similar Text in Two Columns in Excel (3 Easy Ways)

Depending on the circumstances you may need to find similar text within two columns in Excel. Today, we are going to show you how to find similar ...

ExcelDemy
Logo