Today I was working on excel (yeah yeah I do work sometimes), I wanted to extract the first 20 characters from the string. I forgot the function name, I did a quick google search and found out the solutions.
left(A1,20)
This is the function to extract first 20 characters from A1 cell!!
Simple.
PS - I am writing this blog because I may require to do so in future, may be 10 years. So I will check back my blog.