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.
Free courses
Latest Video
Latest Comic
Want to contact me?
Ravi Sagar
ravi at sparxsys dot com
Author of "Mastering JIRA 7" book. Loves #Jira and #Drupal. #Blogger, #ProblemSolver, #Atlassian #Consultant and #Technologist @ravisagar on twitter
Want my help? raise a support request for me.
Social and other Links
- RSS Feed
- Github
- @ravisagar on Twitter
- Ravi Sagar YouTube: Atlassian tools and Jira tutorials
- Ravi Sagar LBRY: Synced with Ravi Sagar YouTube
- Blackberry Boy YouTube: Linux, Emacs, Org Mode and tech tutorials
- Ravi Sagar Podcast
- @ravisagar.in on Instagram
- Ravi.pro: site published with Org Mode, general IT and tech stuff
- LinuxIndya.com: site published with Org Mode on Linux
- AutoGrid.info: site published with Org Mode on Excel VBA and Google Apps Script