MICROSOFT EXCEL FUNCTIONS- TEXT

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 …
Read More

EXCEL FUNCTIONS-TRIM

INTRODUCTION TRIM function comes under the TEXT category in Excel. Think of a scenario where you copy some text from …
Read More

EXCEL FUNCTIONS-TEXT

INTRODUCTION TEXT FUNCTION is found under the TEXT FUNCTION CATEGORY of Excel. TEXT FUNCTION is specially created to format the …
Read More

EXCEL FUNCTION-SUBSTITUTE

INTRODUCTION Think of a scenario! We have a report and we want to change a portion of the text after …
Read More

EXCEL FUNCTION-SEARCH

INTRODUCTION SEARCH FUNCTION is one of the very important and useful functions in Excel. As SEARCH FUNCTION is concerned with …
Read More

EXCEL FUNCTIONS-RIGHT

INTRODUCTION RIGHT function comes under the TEXT category in Excel. RIGHT FUNCTION is used if we need to extract a …
Read More

EXCEL FUNCTION-REPLACE

INTRODUCTION Think of a scenario! We have a report and we want to change a portion of the text after …
Read More

EXCEL FUNCTIONS-PROPER

INTRODUCTION PROPER function comes under the TEXT category in Excel. PROPER FUNCTION capitalizes first letter of every word in a …
Read More

EXCEL FUNCTIONS-MID

INTRODUCTION MID function comes under the TEXT category in Excel. MID FUNCTION is used when we need to extract letters …
Read More

EXCEL FUNCTIONS-LOWER

INTRODUCTION LOWER function comes under the TEXT category in Excel. LOWER FUNCTION converts upper case to lower case of the …
Read More