Click here to download the excel file which contains the below examples Description of Excel SUBSTITUTE Function SUBSTITUTE: This function will help us to replace the whole or part of the old text with newContinue reading
Category: TEXT Functions
Excel TEXT functions Syntax List
Below the list of Excel TEXT functions along with Syntax S.no Function Name Syntax 1 REPLACE REPLACE(old_text,start_num,num_chars,new_text) 2 LEN LEN(text) 3 UPPER UPPER(text) 4 LOWER LOWER(text) 5 PROPER PROPER(text) 6 RIGHT RIGHT(text,[num_chars]) 7 LEFT LEFT(text,[num_chars])Continue reading
How to use REPLACE Function in Excel
Description of Function Replace Function will help to replace part of the existing text with another text. Replace function in Excel Syntax of REPLACE Function Syntax of Replace Function Syntax: REPLACE(old_text,start_num,num_chars,new_text) Arguments:- All 4 argumentsContinue reading
How to use REPT function in EXCEL 2016
How to use REPT function in Excel 2016 REPT function will give us the option to repeat a particular text for the required number of times in one cell. Description of REPT function in ExcelContinue reading
How to Use TEXTJOIN Function in EXCEL
Excel 2016 TEXTJOIN function with Delimiter option In Excel 2016 we have a new TEXT function with a delimiter option. TEXTJOIN function Description This function will help users not only joining the text but also allows to give aContinue reading
How to use T function in Excel
Description of T function This function will help to identify and give the same result if the given value is TEXT, if not then the result will be a blank cell. T Function Description Syntax:-Continue reading