| Be My Friend

Text Functions in Excel

Left | Mid | Right | Length | Find | Lower | Upper | Trim

In this tutorial, we are going to discuss Text Function in Excel with examples like Left, Right, Len, Mid, Etc formula.

In Excel, we have multiple functions to perform texts like trimming cells, splitting text from the right, finding the length of the text, etc.

Below are some of the most frequently used text formulas in Excel with examples.

Left

To get the leftmost texts from a string, use the LEFT function in Excel.

It returns a specified number of characters from the start of the text.

Left Function in Excel

MID

To get the leftmost texts from a string, use the LEFT function in Excel.

It returns a specified number of characters from the middle of a text string.

MID Function in Excel

Right

It returns a specified number of characters from the end of the text.

Right Function in Excel

Len

To get the Length of a string, use the LEN function in Excel.

It returns the lenght of a text string.

LEN Function in Excel

Note: spaces also consider here.

Find

To find the position of a given character in a string, use the FIND function in Excel.

FIND Function in Excel

Note: case sensitive is there.

Lower

To convert all the characters into lowercase use the LOWER function in Excel.

Lower Function in Excel

Upper

To convert all the characters into uppercase use the UPPER function in Excel.

Upper Function in Excel

Trim

To remove spaces at the start and end of a text or to remove duplicate spaces the TRIM function in Excel.

Trim Function in Excel

You May Also Like the Following Excel Tutorials:

IF YOU LIKE OUR EXCEL TUTORIALS PLEASE DON'T FORGET TO SHARE

Subscribe for more videos on our Youtube channel. if you like our tutorial please Like and Subscribe to our Facebook and Youtube.

Download the Sample Text Function in Excel file for free.

To Get FREE Excel Shortcut Keys
       



Previous

Start Over

Why basictutorials.in?

To Learn:

Tutorials in a simple Way.

Excel with downloadable samples.

HTML with sample website code.

PowerPoint presentations.

MS Word for offical use.

Useful Tutorials