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

Submitted by ravisagar on Mon, 11/29/2010 - 06:28

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) is the function to extract first 20 characters from A1 cell!!

Want to contact me?

Life begins outside your comfort zone and that is where your courage is developed". Write to me by filling this form. For living I am an Atlassian Consultant who love both Jira and Drupal. I am the author of "Mastering JIRA" and "Mastering JIRA 7" books. I Love both JIRA and Drupal (a bit more). You can Write To Me and I will get back to you as soon as I can. Have a nice day!

Social Links

Subscribe to my mailing list.

Enter your email address: