# Microsoft Excel

## Microsoft Excel – Text Functions – TRIM and REPT formulas

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 […]

## Microsoft Excel – Text Functions – REPLACE, REPLACEB and SUBSTITUTE formulas

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 […]

## Microsoft Excel – Text Functions – LEFT, LEFTB and RIGHT, RIGHTB formulas

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 – Text Functions – LOWER, PROPER and UPPER formulas

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 […]

## Microsoft Excel – Text Functions – BAHTTEXT, DOLLAR and DBCS formulas

Continuation to our series of Articles of Text Functions; in this Article, we will discuss 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 pass […]

## Microsoft Excel – Text Functions – CONCAT, CONCATENATE and TEXTJOIN formulas

Through the series of Articles, we are discussing about different types of functions in Microsoft Excel. In this Article, we will discuss 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 – CLEAN, CODE, VALUE and NUMBERVALUE formulas

In our previous Article, we have discussed few Text Functions in Microsoft Excel. In this Article, we will discuss few more Text Functions. CLEAN Function This function is used to remove all the non-printable characters from the given text. In ASCII character set, the codes from 0 to 32 are non-printable characters. This functions look […]

## Microsoft Excel – Text Functions – ASC, CHAR, UNICHAR and UNICODE formulas

Microsoft Excel Text Functions are useful to deal with the text data. In this Article we will discuss few of the Text functions. ASC function This function returns the ASCII text (single byte characters) from the given text. The give text may contain double byte characters; then the double byte characters will converts to single byte […]

## Microsoft Excel – Logical Functions – TRUE, FALSE and NOT formulas

Set of Logical Functions Microsoft Excel provides to return the logical value, either TRUE or FALSE are going to be discussed through this Article. The logical function TRUE The TRUE() function always returns the logical value TRUE. This function doesn’t have any arguments and when you call this function without parentheses, Excel will treat it […]

## Microsoft Excel – Logical Functions – AND, OR and XOR formulas

I have explained a few logical functions in the Article “Microsoft Excel – Logical Functions – IF, IFERROR and IFNA formulas“. In this article, we will go through another set of logical functions AND, OR, and XOR. All of these formulas take multiple arguments; the first argument is mandatory and the other arguments are optional. […]

Scroll to top