November 2010

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

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

[View]

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!!

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.

I saw hum aapke hai kuan here!!!

Submitted by ravisagar on Sun, 11/21/2010 - 11:57

[View]

I saw hahk in this hall in late 1994 or jan 1995. I was wearing white sweater that turned grey after the movie, coz it was filthy hall. That was movie watching experience 15 years back. The hall was jam packed and people were shouting and whistling. Now multiplexes have killed the meaning of theatre. They have tiny small screen, and hardly I see more than 25% people in the hall.

Just reached the parking

Submitted by ravisagar on Sun, 11/21/2010 - 02:18

[View]

Gng for adhm marathon

My running number bib

Submitted by ravisagar on Fri, 11/19/2010 - 04:47

[View]

This is my running bib for adhm!

Sherkhan on the bus

Submitted by ravisagar on Thu, 11/18/2010 - 03:05

[View]

Nice sticker on the bus!
--
Ravi Sagar
9810949699
Company website: www.sparxsys.com
IP University Guide: www.ggsipu.info
Personal: www.ravisagar.in

The Social Networking - The Movie Review

Submitted by ravisagar on Sat, 11/13/2010 - 03:30

[View]

Yesterday I watched the social network at Fun Cinemas with my wife. Overall the movie was nice, I would say it was good actually. My wife got bored totally and kept asking me questions like what is Napster? What is Monetizing the site? and are these characters real or fake? Most of my time in the movie was spent explaining her that yes these characters are for real and the story too I guess.

Good thing is that before the start of the movie ate chicken momos with spicy sauce and my cough and blocked noses got cleared and I was able to hear everything clearly after that :) (so chicken momos with chilli sauce is cold killer)