Concatenate values using Microsoft Excel

By RAJ On June 28, 2010 · Leave a Comment · In Computer

Concatenate values using Microsoft Excel

It happens all the time. You receive a list of names with the first, middle and surname in separate columns in Microsoft Excel.How do you get them into a list of full names without a ridiculous amount of copying and pasting ?

Just use the concatenate formula.

In the first row of an empty column, type =concatenate(A1, “”, B1), continuing based on the number of columns you wish to combine.

You can customize, too — need spaces between the names ? Put a space between the quotation marks. Writing Enterprise IDs ? Put a period between the quotation marks. Then pull the black box in the corner of the cell down the column to run the formula (or copy and paste) for the whole list. And when you copy the full names into another file, be sure to use Copy>Paste Special>Values.

If you like the post, kindly share it