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 simple formula. So it's starting in C5, just type your equals sign,…

Resume Transcript Auto-Scroll

Author

Released

6/9/2010

In Excel 2010 Essential Training, Bob Flisser demonstrates the core features and tools in Excel 2010. The course introduces key Excel skills, shows how to utilize these skills with in-depth tutorials on Excel functions and spreadsheet formatting. It also covers prepping documents for printing, working with large worksheets and workbooks, collaborating with others, using Excel as a database, analyzing data, charting, and automating and customizing Excel. Exercise files are included with the course.