## How to use Excel T Function

Introduction:- T function are text/string function in excel. It is used to retrieve text from a given text value and also retrieves blank strings for numbers, logical values, dates etc. It is a worksheet function and can be entered in the cell in which value is required. .                                                                 Syntax:- =T(Value) Arguments:- Value: Value or reference … Read more

## How to use Excel JIS Function

Introduction:- JIS function in excel is a text/string function. I. This function is used to convert single byte characters into double byte characters in a text string. This function is useful for multiple languages and unique characters. Half width characters are converted to full width characters. This function was replaced by DBCS function from excel … Read more

## How to use Excel UNICODE Function

Introduction UNICODE function are text/string function in excel. This function is used to find out number corresponding to a Unicode character. Unicode is in form of decimal numbers from 0 to 65535. It retrieves number of first character of a text string. This function was introduced in Excel 2013 and later versions. It is a … Read more

## How to use Excel UNICHAR Function

Introduction UNICHAR function are text/string function in excel. This function is used to find out Unicode character of a defined number. Unicode is in form of decimal numbers from 0 to 65535.This function was introduced in Excel 2013 and later versions. It is a worksheet function and can be entered in the cell of a … Read more

## How to use Excel REPT Function

Introduction REPT function in excel is a built in text/string function. This function is used to repeat characters a given number of times. For example, =REPT(A, 2) gives AA as the result. It is also used as worksheet function and can be entered in cell of a worksheet. Syntax =REPT(Text, Number ) Arguments Text: It … Read more

## How to use Excel SEARCH, SEARCHB Function

Introduction SEARCH, SEARCHB function are text/string function in excel. These are used to locate one text string inside another text string and return its position. It is different from FIND function as it allows wildcards and also not case sensitive. SEARCHB is different from SEARCH only in case of DBCS language setting, otherwise they both … Read more

## How to use Excel TRIM Function to remove extra space

Introduction TRIM function are text/string function in excel. TRIM function is used to eliminate additional spaces from a text and it allows one space to remain between words. It can also be used to omit extra space which have appeared from data copied from other platforms which had irregular spacing. Syntax =TRIM( Text) Arguments Text: … Read more

## How to use Excel NUMBERVALUE Function

Introduction NUMBERVALUE is a text/string function. This function is used to convert text into number with decimals and separator values in it. For example, =NUMBERVALUE(“2000.990”, “,”, “.”), it gives 2000.99 as the answer. This is a worksheet function and can be entered into the cell in which you wants answer. Syntax =NUMBERVALUE(Text, decimal_separator, group_separator) Arguments … Read more

## How to use Excel TEXTJOIN Function

Introduction TEXTJOIN function are text/string function in excel. It is used to join multiple text strings with a delimiter attached to it. It also has option to ignore empty values and can also be used to join a range of cells. Syntax =TEXTJOIN(delimiter, ignore_empty, text1, text2) Arguments Delimiter: It is the separator between text values. … Read more

## How to use Excel FIND, FINDB Function

Introduction FIND, FINDB in excel is a text/string function. This function finds one text string within another string and returns its position as a number. This is a case sensitive function. For example, if we have a text string in cell A4 and we wants to find the position of ‘P’ in this string, then … Read more