Last answered:

30 Sept 2022

Posted on:

28 Sept 2022

0

Resolved: What is the purpose of the LEFT function and the other similar functions?

Why use LEFT, RIGHT, MID functions? This wasn't explained further in the video.

2 answers ( 1 marked as helpful)
Instructor
Posted on:

29 Sept 2022

1

Hi Tara,
Good to hear from you.
The reason why you would want to use these functions is that sometimes you will need only the left part of the data you are working with.
For example if you have a column formatted in the following way:
2012.23.24.20421
2013.23.26.24032
2014.24.34.24202

Let's imagine that In this case, the four digits on the left could represent the post code of an address. You can use the LEFT function to retrieve the post code easily. There are many instances when you have to use these functions in Excel. This is just one basic example. Hope I was able to help!
Best,
Ned

Posted on:

30 Sept 2022

1

Thank you for answering, Ned K. I understand more clearly now.
Thank you,
Tara G.

Submit an answer