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 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.

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.

How to attend phone Interview

Looking for tips on how to be effective during a phone interview for a job? This article provides useful tips for novices who are participating in their very first phone interview with a prospective employer.

How To Diagnose and Prevent Dengue Fever

This article tells about the expressions of Dengue fever and how to understand if a person is suffering from Dengue fever. Also read further to know about the investigations for Dengue Fever and treatment for Dengue fever.

More articles: 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: