How to combine cells in Excel

How to combine cells in Excel

Have you ever been working with a list in Excel and had to combine more than two cells into a new cell? The seemingly easiest way to do this is to copy the contents from both cells and paste them into the new cell, then edit them for spacing. But, did you know that there is actually a formula called concatenate that you can use to combine contents and display this in new cells?

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:

=CONCATENATE(A2,B2).

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

=CONCATENATE(A2,” “,B2)

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.

New themes for Office 365

New themes for Office 365

When it comes to purchasing and implementing public cloud solutions, such as Microsoft’s Office 365, business owners know that they are getting pretty much exactly the same product as every other business that uses the same solution. While this uniformity and consistency is positive, users often look for ways to customize the platform so that it relates more directly to a specific company.

Google launches new Drive app sites

Google launches new Drive app sites

If you are a Google Drive user, you may have noticed that Google has been implementing a number of changes over the past few months. First there was a change to the look of the file sharing service, then to how you accessed files. Now the tech company has announced that they have launched separate sites for their productivity apps.

Juice jacking 101

Juice jacking 101

With smartphones playing a larger role in today’s daily business, the need to recharge them while you are on the go increases. And when you’re nowhere near your charger, that public charging kiosk can look pretty promising. But what you might not know is that common traits in smartphone hardware and software design makes recharging phones through public chargers prone to juice jacking.

Business impact analysis tips

Business impact analysis tips

Many people wonder why it’s necessary to perform business impact analysis (BIA) when they’ve already invested a large amount of time on a risk assessment. The answer is simple: because the purpose of a BIA is different, and wrong results could incur unnecessary expenses or create inadequate business continuity strategies.

Top 3 cloud service models

Top 3 cloud service models

At any given time there are a nearly countless number of technology related trends popping up. Many come and go, but one of the most important that many business owners are focusing on is the cloud. Owners and managers know they ought to be using “the cloud” but it can be confusing as to what exactly it is and the different types of services available.

Search operators for Google Drive

Search operators for Google Drive

For many Google Apps users Google Drive is among the most important and popular app. With a wide scope of features, including document creation, collaboration tools, and cloud-based storage, the app is highly useful for almost any business across any industry.