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.

Tips to Give CAT examination 2011

How to apply to CAT examination 2011? Duration of CAT 2011? Marks pattern of CAT 2011? When CAT result will be declared? How to apply to CAT exam 2011? In this article you will find answers of all such questions. For detailed information kindly read the article below.

Some Selection Strategy Tips for CAT Allied B-Schools

If you wish to study in CAT allied schools on CAT based score, this is the right time to apply for admission lest the date to apply slips by and you miss the bus. If it happens so, you shall miss the golden chance even after obtaining better percentile in CAT. What type of is required for selecting a better B-School and seeking admission into it forms the subject matter of this present dissertation.

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.

What are the key factors to success in CAT?

CAT is such an examination through the medium of which, you could reach to the top. This is the reason why lacs of students every year round try their luck in this examination but a very few select are able to make it at the top of the merit list. This article helps in letting you know how best to traverse the pathways to success in this stiffly tough examination.

More articles: CAT How to

Comments

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:
    Email: