Join the social network of Tech Nerds, increase skill rank, get work, manage projects...

How to Remove leading or trailing spaces in an entire column of data?

Hello everyone, Some times we need to remove the leading, trailing spaces or space in between the text in an entire column of data, one can might think to go manually but what if you have large set of data, the manual process wi...

How to split text in Google spreadsheet or excel?

Many time we need to split the data in our spreadsheet for this we can use SPLIT formula lets take an example, I have a large set of data which includes mail address like,, in column A, so if I need to s...

Hide Columns and Rows in Excel

Hiding columns and rows is useful to intensify the appearance of Excel Worksheet as the columns and rows which contains data which are not useful to keep displaying every time. So if you are looking to know how to hide the columns and rows i...

How to use Sub Total Function in MS Excel and Open Office Calc

Hi, In this session I am going to cover, How to use sub total feature in openoffice calc and Excel. Let's take an example- I have a data of Employees Name, month of joining and salary. I want to get Grand total and subtotal. Grand total w...
Sign In

Sign up using

Forgot Password
Fill out the form below and instructions to reset your password will be emailed to you:
Reset Password
Fill out the form below and reset your password: