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 to a cell containing value whose text will be returned. Keynotes:- This function gives empty  strings for numbers, logical values, dates etc Examples In this…

Continue Reading

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 2013 onward. For example, =JIS(“PRINCE) gives PRINCE as the result. Syntax:- =JIS(Text) Arguments:- Text: It is the text or reference which contains the characters you…

Continue Reading

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 worksheet function and can be entered in the cell of a worksheet. Syntax =UNICODE( Text) Arguments Text: It is the text string or a single…

Continue Reading

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 worksheet. Syntax =UNICHAR( Number) Arguments Number: It is the number which will be used to find the Unicode character Keynotes Unicode character retrieved may also…

Continue Reading

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 is the text or reference to a cell containing the text, which will be repeated Number: Number of times you wants to repeat the text.…

Continue Reading

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 behave as same. Syntax =SEARCH(Find_Text, Within_Text, Start_Num ) =SEARCHB(Find_Text, Within_Text, Start_Num ) Arguments Find_Text: The text or reference to the cell containing the text, whose…

Continue Reading

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: It is the text or reference to a cell containing the text whose extra spacing needs to be removed. Keynotes This function is useful for…

Continue Reading

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 Text: It is the text which will be converted into number.Decimal_Separator: It is the character used as decimal separator in the text.Group_Separator: It is the…

Continue Reading

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. Ignore_empty: Logical argument which decides whether empty values should be ignored or not. Text1: It is the first text or range. Text2: It is the…

Continue Reading

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 we use the function =FIND(“P”,A4) and gets result in form of a number, if the text is not present, #VALUE error is displayed. Syntax =FIND(Find_Text,…

Continue Reading
Close Menu
×

Cart