Excel string functions

How to use TRIM function in Excel (7 Examples)

Excel provides several text functions to help you perform your desired tasks easily and swiftly. Today we are going to show you how to use a text ...

How to use SUBSTITUTE function in Excel (4 Examples)

There are several text functions in Excel to help you perform your desired tasks easily and swiftly. Today we are going to show you how to use a text ...

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 Use SEARCH Function in Excel (3 Examples)

Today I will be showing how you can use the SEARCH function of Excel to search for a particular text within a given string. SEARCH Function of ...

How to use PROPER function in Excel (2 Examples)

There are several text functions in Excel to help you perform your desired tasks easily and swiftly. Today we are going to show you how to use a text ...

How to Use TEXT Function in Excel (10 Examples)

In Microsoft Excel, the TEXT function is generally used to convert a numeric value to a specified format for various purposes. In this article, ...

How to Use RIGHT Function in Excel (With 6 Easy Examples)

RIGHT is another popular function in MS Excel that is used to get the last character or characters in a text string, based on the specific number of ...

How to Use MID Function in Excel (3 Examples)

Today I will be showing how you can extract some specific number of characters starting from a specific position of a string using the MID function ...

How to use LEFT function in Excel (4 Examples)

Excel provides several text functions to help you perform your desired tasks easily and swiftly. Today we are going to show you how to use a text ...

How to Use REPT Function in Excel (8 Suitable Examples)

In Microsoft Excel, the REPT function is generally used to repeat a text or a character a defined number of times in a cell. In this article, you’ll ...

How to Use LOWER Function in Excel (6 Easy Examples)

MS Excel provides us with various functions to help us customize the case of the text. Among them, the LOWER function is used to change the case of ...

How to Use REPLACE Function in Excel (3 Suitable Examples)

In Microsoft Excel, the REPLACE function is generally used to replace or substitute a text. The replacement is based on its starting position and ...

How to Use FIND Function in Excel (7 Suitable Examples)

In Microsoft Excel, the FIND function is generally used to extract the position of a defined text in a cell containing a text string. In this ...

How to Use LEN Function in Excel (Formula and VBA Code)

Excel provides a function called LEN for counting letters, numbers, characters, and all spaces. LEN is a short form of LENGTH. LEN function is used ...

How to Use CONCATENATE Function in Excel (4 Examples)

Today I will be showing how you can join two or more texts or numbers into one single text value using the CONCATENATE function of Excel. ...

ExcelDemy
Logo