How to use Concatenate function in MS Excel

While working in MS Excel, did you ever struggle to combine values of multiple cells into one cell? Were you copy-pasting the values one by one for all the records? If yes then here is the trick that you can use to perform the task easier.

This article is about one of the functions that Microsoft Excel helps in performing the task easier for someone who is looking to add or combine the two cells data into one using the function Concatenate. There are lot many functions available in the Excel with different purposes and one of them is explained here with step by step how to concatenate.

Fortunately, there are some functions that can alleviate such pain. Concatenate is one such function that can combine the values present in two cells into one cell.

Let's take an example. Consider a list of 300 customer first names and last names in columns A and B. Here are simple steps you can take to combine these names in column C.

  1. Click a cell, say C1.

  2. Click the Formulas tab.

  3. Click Text to open the function drop-down list.

  4. Select CONCATENATE. A Function Arguments dialog box appears.

  5. Click the text line Text1 and select first name in the first cell in column A.

  6. Click the text line Text2 and enter a single space.

  7. Click the text line Text3 and select last name in the first cell in column B.

  8. Click OK. The combined customer name appears in C1.

Don't worry about repeating this for each of the 299 remaining cells in column C. Just place the cursor in the first cell in column C. Then, drag the Fill Handle all the way down to the 299 cells. All customer names get combined and appear in column C.

So, take some time and explore various Excel functions. You will realise that Excel makes it much easier to interpret numbers and information!

Other commonly used functions in Excel in use are as follows.
SUM: Adds all the numbers in a range of cells.
IF: Checks whether a condition is met, and returns the value if TRUE, and another value if FALSE
COUNT: Counts the number of cells in a range that contains numbers.

Related Articles

How to prevent acne scars?

This article explains various measures which keep acne under control. This decreases inflammation and consequently chances of formation of acne scars too decreases. Actions like not picking at skin, proper hydration, using sunscreen lotions, proper skin care regime etc prevent formation of acne scars.

How To Control Anger?

Have you ever been angry and later on felt sad for being angry on some one or something? Do you want to control your anger ? Is anger good or not ? The following article will discuss about anger and measures through which we can control our anger.

How to remove blood stains from delicate fabrics and specific surfaces?

This article explains various tips and methods to get rid of blood stains from delicate fabrics like silk, satin, woolen, linen etc and from specific surfaces like concrete, hardwood floors, mattress, quilt, leather, carpets etc. These methods used can make them free from blood stains.

Top 9 tips and exercises to sharpen the mind and boost brainpower

The brain needs constant stimulation to remain alert and active. Practice good habits that can sharpen your memory and help you stay alert and on top of your game at all times. Simple lifestyle changes that involve the number of you sleep or what you eat or how you relax can play a great role in how your brain functions. Find out what you need to do right, to get the best out of your grey cells.

How to become a pathologist with top hospitals in India

Are you looking for a career in medicine as a clinical pathologist? Need to know how to start a pathology lab? This article provides complete information on the different specializations in pathology and a career guide on starting a career as a pathologist. You will also get a general idea on the approximate costs of setting up your own path lab.

More articles: How to


No responses found. Be the first to comment...

  • Do not include your name, "with regards" etc in the comment. Write detailed comment, relevant to the topic.
  • No HTML formatting and links to other web sites are allowed.
  • This is a strictly moderated site. Absolutely no spam allowed.
  • Name: