# Category: TEXT Functions

#### How to use Excel LOWER Function

Quick view of Excel LOWER Function Explanation: In the above table, the LOWER function is applied to the data and the results are from D7 to D10. The formula can…

#### How to use Excel UPPER function

Quick view of Excel UPPER Function How to use Excel Upper Function Explanation: In the above table, Excel UPPER function is applied to the data and the results are from…

#### How to use Excel PROPER function

Quick view of Excel PROPER Function How to use Excel Proper Function Explanation: In the above table, the PROPER function is applied to the data and the results are from…

#### How to use Excel RIGHT function

Quick view of Excel RIGHT Function Explanation: In the above table, the RIGHT function is applied to the data and the results are from D25 to D32. The formula can…

#### How to use Excel LEFT Function

Quick view of Excel LEFT Function Excel LEFT function Explanation: In the above table, LEFT function is applied to the data and the results are from D7 to D15. The…

#### EXCEL TEXT Function to format Date and Time

Click here to download the file used for below exmaples TEXT Function: The TEXT function lets you change the way a number appears by applying formatting to it with format…

#### How to Use Excel SUBSTITUTE Function

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…

#### 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:…

#### 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…