Python, C, C++, C#, PowerShell, Android, Visual C++, Java ...
We have discussed in our Previous Article on how to extract partial text in Excel using LEFT, LEFTB and RIGHT, RIGHTB functions. In this Article, we will discuss another set of Text Functions in Microsoft Excel for the same purpose; to extract partial text from the given text. MID and MIDB functions MID and MIDB […]
In this Article, we will discuss about another set of useful Text Functions Microsoft Excel provides to search the text in the given text. The EXACT formula This function is used to compare two given text values and returns TRUE if both the values are match. The comparison is case-sensitive. That means, “Apple” and “apple” […]
Another set of Text functions SEARCH and SEARCHB in Microsoft Excel are useful to find the text within the given text. These functions returns the index value where it finds the text in the given text. These functions are non case-sensitive. That means, these considers the text “APPLE” and “apple” as same. SEARCH formula This […]
When dealing with data, Microsoft Excel provides a lot of useful Text functions. We will discuss another set of Text functions; TRIM and REPT in this Article. The TRIM formula This function is used to remove all the leading and trailing spaces in the given text. We can pass the text directly to the function […]
The set of text functions in Microsoft Excel are used to replace the text with the new text. These functions are widely used when deal with the data. We will discuss usage of these functions in this Article. The REPLACE formula This function is used to replace part of string in a given string with a […]
Another set of Text Functions in Microsoft Excel are useful to extract the partial text from the given text. These functions have two variations; one variation considers number of characters to return and the other variation (with B suffixed) considers the number of bytes to return from the given text. The functions (with B suffixed) […]
Microsoft Excel provides set of Text Functions to alter the given text to lowercase, uppercase and capitalize of each word. In this Article, we will discuss the set of functions to be used to convert the text to lower, upper and capitalize. All these functions takes text as an argument. We can give text directly […]
Continuation to our series of Articles of Text Functions; in this Article, we will discuss a few more Text Functions from Microsoft Excel. BAHTTEXT function This function is used to convert a number to Thai text. This function takes a number or numeric text as an argument and converts it to Thai text. If we […]
Through the series of Articles, we are discussing different types of functions in Microsoft Excel. In this article, we will discuss a few more Text Functions in Microsoft Excel. We are going to use below Table of values in this article, and we apply these formulas to combine the strings to see the results. ♦ […]
Microsoft Excel Text Functions are useful to deal with textual data. In this article, we will discuss a few of the Text functions. ASC function This function returns the ASCII text (single-byte characters) from the given text. The given text may contain double-byte characters; then the double-byte characters will convert to single-byte characters. If the […]