Jira Courses, Training and Consulting: Sparxsys Trainings
Thanks for coming here, I hope you are enjoying learning here, I have also written some books in case you want to learn a bit more :)
If you need my help with Drupal, Linux, Jira, Scripting, Automation or want to contact me then raise a ticket for me please :) and I will get back to you, promise. At Sparxsys we provide Atlassian consultancy services, reach out to me at ravi at sparxsys dot com

Excel Tip - How to extract first 20 characters from the string

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.

Syndications

Similar posts

Subscribe

* indicates required

Please confirm that you would like to from Sparxsys:

You can unsubscribe at any time by clicking the link in the footer of our emails. For information about our privacy practices, please visit our website.

We use Mailchimp as our marketing platform. By clicking below to subscribe, you acknowledge that your information will be transferred to Mailchimp for processing. Learn more about Mailchimp's privacy practices.

Want to contact me?