Microsoft Office is one of the most installed software suites in the world. If you are looking to integrate it into your company, you can either purchase Microsoft Office 2019 or sign up for cloud-based Office 365. Both promise the same features that the Office suite is known for, but they are different enough to […]
Time is the commodity of service providers — therefore being able to manage it well ensures profitability. To maximize your schedule, use Bookings by Office 365. Here’s how this easy-to-use app can greatly benefit your business. Visibility Bid adieu to the days of scribbling on post-its and frantically going through your schedule to find out […]
Office 365 receives updates so often that they’re hard to track. But the software suite’s basic calendar functions will always be among the most popular. If you’d like to let people outside of your organization see your calendar, all it takes is a few clicks. Share an Office 365 calendar with specific people Click the […]
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)
Clicking on cell A2 and then adding a comma (,)
Clicking on cell B2 and closing the formula with a closing bracket
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.
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.
Microsoft Outlook delivers more than many business people perceive it to do. More than just an email application, this program can also handle important notes, reminders, and details of business matters through Outlook Address Book. Though it is more often used to pull out the email addresses of your contacts, the address book is also a great tool to organize and sync client details to another application.
The word processor is one of the integral pieces of software at a business's disposal. While there are more than a few options available to users, the most useful has to be Microsoft Word. With a variety of useful features, users can create almost any style of document.
One of the features of Microsoft Office applications is the research pane. It used to be accessible from review menu of a Word document. With the release of Microsoft Office 2013, it appears that research button can no longer be seen under the review tab.
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.
Microsoft Office might not be the program that is top of mind with users these days, but you cannot deny the legendary success it has seen over the past 20 years. Moreover, the platform is still one of the most sought-after enterprise software products in the market.