## Convert Text to Columns

With Excel there is always more than one way of completing a task. Previously I have written a post about splitting date and time from being combined in one …

With Excel there is always more than one way of completing a task. Previously I have written a post about splitting date and time from being combined in one …

Using Variables in Excel VBA A Variable is used to store information temporarily so that it can be used for execution within the Procedure, Module or the …

Worksheets in Excel 2003 can contain 65536 rows and 256 columns. So to work out the number of cells per worksheet, simply multiply 65536 x 256 = …

In this post I hope to show you a work around for reducing a string to two decimal places. I was working on a project just recently for a reporting system for …

In Excel 2003, there are 16,777,216 cells in a worksheet. There are 256 columns and 65,536 rows. Then doing the maths: 256 x 65536 = 16,777,216 cells. In Excel …

There are 256 columns available in each worksheets in Excel 2003. However, in Excel 2007 I believe there is no

Excel 2003 has a maximum of 65536 rows per worksheet. But did you know that Excel 2007 offers an almost unlimited number of rows per worksheet, over one …

A quick way to get and show the lowest number in a range of cells, instead of using the =MIN function by hand, is to use the auto min button in excel. All …

Converting a row to a column, or column to a row, is very easy in Excel using the transpose feature. Often you find yourself presented with data in rows, but …

In a previous post I talked about how to use the COUNT function in Excel to count the number of cells containing data. Well, you can also combine COUNT with …

A quick way to get and show the highest number in a range of cells, instead of using the =MAX function, is to use the auto max button in excel. All you do …

A quick way to get an average from a range of cells, instead of using =AVERAGE function, is to use the auto average button in excel. All you do is click in …

An even quicker way to sum a range of cells, instead of using =SUM function, is to use the auto sum button in excel. All you do is click in the cell directly …

If you have a lot of data that you need to select in a column, and can’t do so by selecting the whole column, a very quick way is using a key board short …

Using Excel VBA you can get the username of the person logged into the computer and print it to a cell. I have used this before to monitor which users on a …

Did you know that using Excel VBA you can get the computer name and print it to a cell. I have used this before to monitor which computers on a network where …

In a previous post I talked about how to SUM cells using Excel’s SUM function. This is a great way to sum cells quickly, but did you also know you can …

Before Excel 2007 the maximum number of rows per worksheet was 65000! And if you had numbers in just a thousand of those, and needed to a total of all the …

When using Excel, it’s often beneficial to know how many cells that contain data there are in a range. A real easy to work this out is using the COUNT …

Have you ever needed to show the current date and time combined into one cell? Simple solution is to click into the cell you want it displayed and type …

Sometimes it is required to always have the current date displayed on a workskeet whenever you open it. A very quick and easy method is to type =TODAY() in a …

Hopefully you have come to this post after reading my previous article about using IF functions in Excel. This is a next step to using IF in Excel. …

The IF Statement in Excel is a good tool, but is quite often little understood by Excel users. The IF statement tests a value and then says whether it is …

This was a request from a reader who wanted to know how to add and use a command button that was controlled from a worksheet in Excel. Lets assume we will use …

The MID function in Excel allows you to extract a set number of characters from the middle of a string. For example you may have in cell A1 …

The LEFT function is excel allows you to extract a set number of characters from the left hand side of a string. For example you may have in cell A1 …

The RIGHT function in excel allows you to extract a set number of characters from the right hand side of a string. For example you may have in cell A1 …

Sometimes in Cells you will have several blank spaces at the beginning and/or end of a string, example “SPACE ” or ” SPACE” …

I have worked with data downloads from companies where the date comes out of the database it is in an unsable format for date purposes. Instead of displaying …

Normally to view a hidden sheet a user could go to the menu and click Format > Sheet > Unhide. Then the user could select the sheet that they wish to …

Sometimes when you receive data in an Excel file that has been downloaded from a database the date and time are in the same column together (as shown in column …

The SumProduct feature in Excel is, I think, a fantastic formula that is so often under used. It allows you to multiply corresponding values in your chosen …

We use cookies to personalise content and ads, to provide social media features and to analyse our traffic. We also share information about your use of our site with our social media, advertising and analytics partners. How Google uses data when you use our partners' sites or apps

The cookie settings on this website are set to "allow cookies" to give you the best browsing experience possible. If you continue to use this website without changing your cookie settings or you click "Accept" below then you are consenting to this.