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.
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
Thank you for answering, Ned K. I understand more clearly now.
Thank you,
Tara G.