Excel String Functions Archives

How to Use CODE Function in Excel (5 Examples)

Nov 14, 2022 Excel Functions

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)

Jun 19, 2022 Excel Basics

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 Use FIXED Function in Excel (6 Suitable Examples)

Feb 9, 2023 Excel Functions

The FIXED function is a built-in function in Microsoft Excel. It is categorized as a String/Text Function. It is one commonly used procedure in ...

How to Use CLEAN Function in Excel (10 Examples)

Feb 26, 2023 Excel Basics

The CLEAN function is an Excel text function that is used to remove non-printable characters or line breaks from texts of a dataset. In this article, ...

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

Feb 28, 2023 Excel Functions

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 the SUBSTITUTE Function in Excel (7 Examples)

Jan 18, 2023 Excel Functions

The SUBSTITUTE function is one of the text functions available in Excel that replaces the existing text with new text in a string. If you want to ...

How to Use UPPER Function in Excel (4 Examples)

Nov 11, 2021 Excel Functions

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 Suitable Examples)

Jan 18, 2023 Excel Formulas

in excel, we need to deal with a large number of formulas and functions. Moreover, the Excel SEARCH function is quite familiar function in use. This ...

How to Use TEXT Function in Excel (10 Examples)

May 12, 2022 Excel Functions

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 (6 Suitable Examples)

Jan 18, 2023 Excel Formulas 2

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 (5 Ideal Examples)

Jan 18, 2023 Excel Formulas

While working in Excel, we often need to extract a specific number of characters from a cell. This can be achieved by both the LEFT and the RIGHT ...

How to Use LEFT Function in Excel (4 Suitable Examples)

Jan 17, 2023 Excel Functions

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)

Sep 11, 2022 Excel Functions

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 Excel LOWER Function (5 Suitable Examples)

Jan 17, 2023 Excel Formulas

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)

Sep 11, 2022 Excel Functions

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