From the course: Excel 2010 Essential Training

Unlock the full course today

Join today to access over 22,400 courses taught by industry experts or purchase this course individually.

Joining data from multiple cells

Joining data from multiple cells - Microsoft Excel Tutorial

From the course: Excel 2010 Essential Training

Start my 1-month free trial

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. So this is a…

Contents