LEFT, RIGHT & MID

Back to all functions

We can extract characters from a cell containing text in three different ways. The function LEFT extracts counting from the left, RIGHT counts from the right, and MID takes out a section of text from anywhere in the string.
We’ll start by writing Equals, LEFT, select the cell we want, and typing in the number of characters we want to extract from the left. If we write 4, we get the first four characters.
Similarly, we can replace LEFT with RIGHT, to get the last four characters in the cell.
The function MID, however, requires three arguments. We’ll write Equals, MID, select the cell, and then we type which position in the text we want to start extracting from. We then type how many characters, counting from position 6 that we want to extract.
We are left with a 3-character section starting from position 6 in the text.
In this lesson we have looked at how to extract text from three different positions in a string, LEFT, RIGHT, and MID.

Popular courses

The Excel Functions Guide

Deepen and develop your Excel Functions skills

Learn how to efficiently manage databases, clear text in cells, and retrieve values from other tables. The course also walks...

Excel Essentials

Get a better understanding of the Excel workflow

Learn to feel more comfortable in Excel. This course will help quickly develop your knowledge in Excel. Excel Essentials is...

Contact us for assistance in finding right course

Excel for your profession

The Excel course for Procurement and Logistic professionals

Excel for professionals working within procurement and logisticians

In cooperation with organisations and professionals within the industry, Learnesy have developed an Excel course that is adapted to those...

Looking for something custom made? Contact us and we will make sure to meet your requirements.

Contact