Text

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 …

How to use Excel T Function 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 …

How to use Excel JIS Function 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 …

How to use Excel UNICODE Function 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 …

How to use Excel UNICHAR Function 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 …

How to use Excel REPT Function 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 …

How to use Excel NUMBERVALUE Function 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. …

How to use Excel TEXTJOIN Function Read More »