Using concatenate in Excel

If you use Excel there is a good chance that you have used a wide variety of formulas. But, when it comes to working out how to combine the content of different cells into a new one, without adding them together, many users will simply cut and paste. Did you know though that the concatenate formula can also do this for you?
Using the concatenate formula to combine cells
If, for example, you have a spreadsheet with first names in column A, last names in column B, and want to combine them into column C to display the full name you can do so by:

Clicking on cell C2 (or the row where the information you want to combine is)
Typing =concatenate(
Clicking on cell A2 and then adding a comma (,)
Clicking on cell B2 and closing the formula with a closing bracket
Hitting Enter

You should see the two cells are now combined in cell C2, with the formula for cell C2 reading:


The problem is, there will be no space inbetween the letters or numbers, so you will need to edit the formula to read:


The double quotations with a space in between them tells Excel to add a space to the cell in between the contents of A2 and B2.

If you have more than two columns you would like to combine, then simply add a comma after each cell.

Excel headers and footers 101

Microsoft Excel has become an increasingly versatile work application catering to most businesses, big and small. While most users are familiar with all the functions the app has to offer, many are still unaware that you can add a header or footer to your spreadsheets.

Outlook’s new search folder

Microsoft Outlook is an application used for managing personal information including email, tasks, contacts, and calendars. It is one of the programs that is included when you install Microsoft Office on your computer. While Outlook has many useful features, one of the most useful is the ability to create new search folders which let you conveniently access priority emails.

Freeze and split panes in Excel

Microsoft Office is one of the more popular programs, often found on systems regardless of the OS. For businesses one of the more useful Office programs is Excel. Excel has a near infinite number of uses. One problem with Excel is that it almost does too much, and some spreadsheets can become unwieldy.