How To Join Text In Cells With Concatenation In Excel For Mac


show more Joining text in cells with concatenation provides you with in-depth training on Business. Taught by Curt Frye as part of the Excel for Mac 2011 Essential Training show less
please wait ...

Joining text in cells with concatenation

Many times when you use Excel, you'll have to draw information from more than one cell to get the result you want. That's no problem when you want to add numbers together; you can just use a formula. But what if you want to combine several text values? For example, suppose you have a customer's first name and last name, but you need to combine it into a single cell, so that both the first name and last name are there. Other than cutting and pasting or re-typing, you can use a process called concatenation. Concatenation simply means adding one set of characters onto another. If I were to do it by hand, let's say with the name John Smith, I could just type in 'John Smith,' press Return, and I'd have the name.

But let's say that I want to create a formula that will add the value from A4 to the value in B4 to create the name for me. If I want to do that, I can type an Equal sign to start creating the formula, and then there are two ways to do it, and I'll ...

Joining text in cells with concatenation
Video duration: 3m 59s 6h 32m Beginner

Viewers:

Joining text in cells with concatenation provides you with in-depth training on Business. Taught by Curt Frye as part of the Excel for Mac 2011 Essential Training

Subject:
Business
Software:
Excel for Mac
Author:
please wait ...