TEXT FUNCTIONS
TEXT FUNCTIONS
TEXT group of functions contain very important and useful functions which can be used for manipulating text.
This group contains a vast list of TEXTUAL FUNCTIONS which can be used to manipulate text in various ways such as Extracting the text in various ways.
Here is the list of functions which fall under this category. Click the function for its further details i.e. formula syntax, examples, purpose etc.
TEXT FUNCTIONS
EXCEL FUNCTIONS-UPPER
INTRODUCTION UPPER function comes under the TEXT category in Excel. UPPER FUNCTION converts lower case to upper case of the …
EXCEL FUNCTIONS-TRIM
INTRODUCTION TRIM function comes under the TEXT category in Excel. Think of a scenario where you copy some text from …
EXCEL FUNCTIONS-TEXT
INTRODUCTION TEXT FUNCTION is found under the TEXT FUNCTION CATEGORY of Excel. TEXT FUNCTION is specially created to format the …
EXCEL FUNCTION-SUBSTITUTE
Table of Contents INTRODUCTION PURPOSE OF SUBSTITUTE FUNCTION IN EXCEL PREREQUISITES TO LEARN SUBSTITUTE FUNCTION SYNTAX: SUBSTITUTE FUNCTION EXAMPLES:SUBSTITUTE FUNCTION …
EXCEL FUNCTION-SEARCH
INTRODUCTION SEARCH FUNCTION is one of the very important and useful functions in Excel. As SEARCH FUNCTION is concerned with …
HOW TO USE RIGHT FUNCTION IN EXCEL?
Table of Contents INTRODUCTION PURPOSE OF RIGHT FUNCTION IN EXCEL PREREQUISITES TO LEARN RIGHT SYNTAX: RIGHT FUNCTION EXAMPLE:RIGHT FUNCTION IN …
EXCEL FUNCTION-REPLACE
INTRODUCTION Think of a scenario! We have a report and we want to change a portion of the text after …
Make first letter capital in Excel using Proper function
Table of Contents INTRODUCTION PURPOSE OF PROPER FUNCTION IN EXCEL PREREQUISITES TO LEARN PROPER SYNTAX: PROPER FUNCTION EXAMPLE:PROPER FUNCTION IN …
EXCEL FUNCTIONS-MID
INTRODUCTION MID function comes under the TEXT category in Excel. MID FUNCTION is used when we need to extract letters …
EXCEL FUNCTIONS-LOWER
INTRODUCTION LOWER function comes under the TEXT category in Excel. LOWER FUNCTION converts upper case to lower case of the …
