Blog Archives

Excel – How to combine 2 cells into one

Do you have a column containing parts of a full name….that you’d prefer to have in a single cell?

It’s very simple to combine them with a simple Excel formulae.

Joining 2 cells

NOTE: It’s essential to include the double quote marks – and a space – to ensure the correct result.

If you need to do the reverse – split a cell into 2 or 3 (eg. for the first, middle and last name), see this article

 ~~~If you enjoy this article, please click on “Like” to let me know – and/or write a comment below 

Excel – How to split a column in 2 or 3

Do you have a column containing a full name, like this:-

Before

….that you’d prefer to have separated into first and last name ?

It’s very simple to separate them using a few steps in Excel. Here’s how:- Read the rest of this entry

Using Excel’s Autofill feature to save time

If you need to fill in a range of headings, or a column of data, Autofill can really save you time. It can be used for consecutive numbering, days of the week, months of the year, years (such as 2014, 2015 …..) and much more. As long as you have at least the first 2 entries, Excel can generally guess how to continue the series.

Here’s an example of how you begin:-

Freeze panes - 1 Read the rest of this entry

MS Office – Quick Access Toolbar tip

By default, the Quick Access Toolbar is within the program’s Title Bar (as you’ll see in the screenshot below).

MS Office - Quick Access Toolbar 1A

Many users find the Quick Access Toolbar easier to use in a slightly different position – underneath the Ribbon as you can see here:- Read the rest of this entry

Excel columns and rows too small?

The default cell doesn’t allow much room for typing text, does it?

Excel pic about cell width 2

To extend a column’s width, move the mouse pointer over one of the small divider lines that separate the alphabetic headers at the top of the sheet.

When the pointer changes to a double-headed arrow (as you can see in the picture above), press the left mouse button and keep it down whilst you drag the column out until it is wide enough.

The same procedure applies for adjusting row height (ideal if you want to use a larger font) as you place the mouse between the rows and drag.

Bonus Tip – You can automatically size Column A to fit the text inside by simply double-clicking on the border whilst you see the double-headed arrow.

 ~~~

If you enjoy this article, please click on “Like” to let me know – and/or write a comment below 🙂