Use ampersands and CONCATENATE to combine select cell data

- [Voiceover] Sometimes you need to pull data together…from different locations in cells.…I've got a list here.…Column A has the department for these people.…Columns B, C, and D, you can see,…first name, last name, middle initial,…and not everybody has a middle initial here.…Let's say we wanna put these together…by using either a function called concatenate()…or the capability referred to as concatenation.…And we're looking at a worksheet called CONCATENATE.…Let's first use the function: =CONCATENATE()…We see this popping up here, just click it.…

Now, this allows us to pull information together…in any order from different locations.…I like to first get the last name here.…What I really like to create would be…last name, comma, space, first name, space, middle initial.…So what we want to see here is…Baker, comma, space, Mark, space, S.…So last name first,…we'll put in C2, comma.…Following that, we want a comma and a space,…we embed what we want within double-quotes.…So double-quote, comma, space, double-quote.…

Then we want the first name.…