Excel String Functions Archives

How to Use CONCAT Function in Excel

Aug 3, 2023

In this article, we have talked about how to use the CONCAT function in Excel. We have demonstrated various examples of using the CONCAT function ...

How to Use DOLLAR Function in Excel (5 Suitable Examples)

Sep 25, 2023

If you are looking for some special tricks to know how to use the DOLLAR function in Excel, you've come to the right place. We’ll show 5 suitable ...

How to Use DOLLAR Function in Excel (5 Suitable Examples)

FIND and SEARCH Function in Excel (2 Comparison Studies)

Sep 24, 2023

It is a very common occurrence to find the position of a particular character or text within a string. This is helpful for data analysis purposes ...

FIND and SEARCH Function in Excel (2 Comparison Studies)

How to Use CODE Function in Excel (5 Examples)

Sep 24, 2023

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 CODE Function in Excel (5 Examples)

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

Sep 24, 2023

Excel CHAR function (a Text function) gives a specific character when a valid number is given as the input. Some characters are hard to find, you can ...

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

How to Use Excel EXACT Function (6 Suitable Examples)

Sep 24, 2023

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

How to Use FIXED Function in Excel (6 Suitable Examples)

Sep 24, 2023

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

How to Use CLEAN Function in Excel (10 Examples)

Sep 24, 2023

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 CLEAN Function in Excel (10 Examples)

How to Use VALUE Function in Excel (5 Ideal Examples)

Sep 24, 2023

Excel provides several text functions to perform your desired text-related tasks easily and swiftly. One of them is the VALUE function. Today we are ...

How to Use VALUE Function in Excel (5 Ideal Examples)

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

Sep 24, 2023

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 TRIM Function in Excel (7 Suitable Examples)

How to Use the SUBSTITUTE Function in Excel (7 Examples)

Sep 24, 2023

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

How to Use UPPER Function in Excel (4 Examples)

Sep 24, 2023

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 UPPER Function in Excel (4 Examples)

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

Sep 24, 2023

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

How to Use Excel PROPER Function (2 Ideal Examples)

Sep 24, 2023

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

How to Use Excel PROPER Function (2 Ideal Examples)

How to Use TEXT Function in Excel (10 Examples)

Sep 24, 2023

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