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.
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.