Joining data from multiple cells


show more Joining data from multiple cells provides you with in-depth training on Business. Taught by Bob Flisser as part of the Excel 2010 Essential Training show less
please wait ...

Joining data from multiple cells

In this worksheet, we have people's names split into two columns and you can see here in Column A we have people's last names and in Column B we have people's first names. What we want to do is we want to combine first name and last name in the same cell. Well, we need some space to do that. So before anything else, let's go and insert a new column. So put your mouse pointer here on the header of Column C, so your mouse pointer is that down arrow. Click the right mouse button and from the pop-up menu, choose Insert. You can just click over here on what's now C5, so we have some room. Now there is sort of two ways of doing it.

We can do it with the formula. We could also use a function, and there is a function called Concatenate. I think the formula is a little easier to use so we'll do that. Also, I am going to do the exercise wrong first, and the reason is that you have to be careful with spaces, and I want to show you what happens if you are not careful with spaces...

Joining data from multiple cells
Video duration: 4m 18s 6h 21m Beginner

Viewers:

Joining data from multiple cells provides you with in-depth training on Business. Taught by Bob Flisser as part of the Excel 2010 Essential Training

Subjects:
Business Education + Elearning
Software:
Excel
Author:
please wait ...