Blog

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.

New DEA rule makes e-Prescribing harder

New DEA rule makes e-Prescribing harder

The Drug Enforcement Administration (DEA) is making it more difficult for physicians to prescribe opioids, and in doing so, has necessitated changes to e-prescribing.

The issue stems from titles II and III of the Comprehensive Substance Act (CSA), under which controlled substances are classified into one of five schedules based on potential for abuse and likelihood of dependence.

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.

Word 2013 editing feature: Overtype

Word 2013 editing feature: Overtype

As a manager or business owner the chances are good that you spend a fair amount of time editing or compiling documents your employees have created. Many of us use ever popular Microsoft Word to do this, especially when it comes to writing reports or other content.

Changing Android location settings

Changing Android location settings

When you first get your hands on your Android smartphone, you’ll be asked about location services and whether you want to enable them. Google and your carrier will have its own location services that you’ll need to approve as well. But what you might not know is that there are actually a few other options for location services with Android which can affect your smartphone’s security.

What to be aware of with VoIP

What to be aware of with VoIP

VoIP, or Voice over Internet Protocol, has become one of the main forms of voice communication used in businesses of all sizes. Because the system uses an Internet connection, many companies often experience decreased costs while being able to do more with than they could with their traditional phone line.