Crop Cell Contents in Excel

If you are an avid user of excel or use Excel extensively at your work or school, then its good to know the formula built into excel to make your task easier.

For example, if you had a big list of "something" and you need to make a list of it of the first 5 characters, or maybe last 10 characters. Hmmm.

Don't think more, excel has an inbuilt crop function to do that. Use "LEFT" function to retain characters starting from left side of the text, and use "RIGHT" function to retain characters starting from the right end of the text. This below figure should help you understand better.

Its pretty easy right. Now go crop your text data. 

Okay, so what if you wanted to retain all the text from left but the last 3 characters? Don't worry, here is the formula for that. 

Hope this helps!

Google Tasks Canvas Mode

I use Google tasks to manage my to-do lists. Because:

1. It is simple and easy.
2. I already use many Google products like Gmail, GDocs, GCal, and it's easy to sync my tasks. 
3. I use Astrid on my Android phone, and it is synced with my GTasks, and makes my list easily accessible and editable on-the-go.

Anyways, cutting the chase, here is the URL to access Google Tasks as a stand alone tab/webpage. It has a lot of editable features, very user friendly and simple. Just bookmark it and you have to log in using your Google ID. You don't need to now open you GMail to use your lists. 

https://mail.google.com/tasks/canvas 

The other URL without the canvas version, but just like the one you see on on GMail is 

https://mail.google.com/tasks/ig 

You can also bookmark this on your smartphone! The canvas theme can also be bookmarked but it might not align properly on a small screen. I haven't tested, but that's probably the case. 

Hope it helps you!

Same width for all Blogger images

If you are a blogger, you'd definitely take efforts for you blog to make look nicer. I've been looking for various ways for formatting my images on my blog and honestly until now I've been doing them manually for each image. So every time I change the width of the blog or change the template, the images all go may-hem and looks ugly.

On one of my recent "hunts" for formatting blog images, I found this code. And what this does is format all the images to a fixed width. The height automatically adjusts, so yay!