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