All posts

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

Completed 6 working years

Yesterday on 1st April 2009 I officially completed 6 years of my work experience. I have worked in 3 companies during these years. I still fill like a fresher :) I think I have to learn a lot. There are many things that I have never done and want to do.

I don't feel happy about my work experience till now. I think I could have gained more knowledge during these years, instead I wasted lot of my time in the wrong company doing wrong work, working with wrong people.

Well this is not the end. I hope I will do new things in the coming year.

DAV Class XII (Medical section) - Batch 1999

Ravi Sagar Class XIIth 1999 Medical Batch

Updated: September 2020 in paranthesis

1st Row From Left
1.1. Nishant Gupta - He is doing MD from Maulana Azaad, Unmarried (In US, possibly New York)
1.2. Rajbir - Don't know what he is doing these days, ? (In Delhi)
1.3. Arun - He did BAMS, Ayurvedic from Tibya College, ? (In Mumbai)
1.4. Vikas Gupta - He is working in Samsung, Married (In Delhi, working in Hindware)
1.5. Mohit Nasa - Don't know what he is doing, He got married this year (In Hong Kong, working in Infosys)
1.6. Nitin Bassi - I think he is in Delhi (In Delhi, Researcher)
1.7. Mohit Jain - Don't know what he is doing, ? (In Delhi)
1.8. Naveen Jain - Doing his MD in Anaesthology from Pune (In Rajasthan)
1.9. ME - Wasting my life, Unmarried (In UK, Married)

2nd Row From Left
2.1. Shikha - Not sure (In Australia)
2.2. Ruchi Bansal - (In Delhi)
2.3. Garima Gupta - She did her MBA from IIM Kozhikode and now working in Delhi
2.4. Neeti Goyal - (Zoology Honours from Hansraj, thanks Bassi for the information)
2.5. Shilpa - Don't rember her full name
2.6. Tanu - I don't know where is she (In US)
2.7. Manjari - I don't know where is she (In Delhi)
2.8. Ashu Gupta - I don't know where is she (In Mumbai)
2.9. Vibha - I don't know where is she
2.10. Pooja Dhameja - working with TCS, currently in Paris

3rd Row From Left
3.1. Rakhi - I don't know where is she (In Bangalore)
3.2. Vinita - Don't remember her full name
3.3. Nishi - She is in US, after doing her MS from there (In US)
3.4. Suruchi - I don't know where is she
3.5. Abha - Roll number 3! (In Delhi, PHD)
3.6. Payal - Don't remember her full name
3.7. Smriti - (Thanks Bassi)
3.8. Rachna Sapra - I don't know where is she
3.9. Shruti Bhatnagar - I think she is in Bangalore (In Dehradun)
3.10. Neha Nagpal - I think she is in US (In Bangalore)

4th Row From Left - Our teachers
4.1. Mr. Avasthi - Don't remember his last name, Taught us Maths for some time, He improved his handwriting
4.2. Mr. Arun - Physics teacher
4.3. Mrs. Smita - (Home Science teacher, thanks to Payal for sharing)
4.4. Mrs. Kapoor - Vice Principal
4.5. Mrs. Adarsh Kohli - Our Principal, I still remember her signature
4.6. Mrs. Raj - English teacher, She was brought up in Singapore I guess, may be Japan
4.7. Miss Sonia - Biology teacher
4.8. ? - She never taught us anything

Guys please help me with the name of the question marks. I forgot their names.

Missing People in the Photograph
I remember correctly there were 26 Girls + 14 Boys = 40 Total, but in the picture above there are only 28 faces i.e. 11 missing people. Lets start counting them. (I was under this impression that there were 39 students but Bassi corrected me. Actually in the numbering for boys I wrote 1.6 twice :( )

Boys

1. Kapil Minocha - Doing MD from Manipal (In Noida)
2. Raghu - Doing MD from Manipal (In Hyderabad)
3. Chinar - Working in Samsung, Married
4. Sameer - Working in Aricent (In US)

Now 7 girls are remaining.

5. Priyanka Dua (In US)
6. Pooja Dua (In US)
7. Pragati Mathur (In US)
8. Shivani - Married to Chinar (In Delhi)
9. Sonali Parnami (In Delhi)
10. Sheetal Gupta (In Delhi)
11. Surbhita (In Delhi)

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?