Scroll To Top

How to use CONCATENATE Function in Excel?

Posted in Articles, Office3 years ago • Written by Raza Bayani7 Comments

Excel is present with hundreds of Functions but Today we’ll learn about one of the great Excel Functions “CONCATENATE”. It is used for joining values of two or more then two cells. It can be used with the most common Excel Function “IF” and other String & Math and Trig Functions such as: LEFT, RIGHT, MID, REPT,CODE, TRIM, LEN, EXACT, UPPER, LOWER, PROPER, SUM, AVERAGE, COUNT, PMT, IMPT, PV and etc..

We will start with a very simple example.

  • Insert your data table
  • Choose a cell where you want to join the values of different cells.
  • Start with (=) sign then type “CONCATENATE” without qoutes.
  • Open brackets after typing the function Concatenate.
  • Select the values and place “comma” after each word.
  • Look at the example below:
Concatenate Function

Concatenate Function

In the above Example we have three words in different cells (N4, O4 and P4) and we have joined them through the CONCATENATE Function in Cell (Q4).

If you concentrate in the example above we don’t need any space between words in Cell (Q4), but in other cells below that we can see that there is a SPACE between each name or word. So while working with CONCATENATE Function we have to be careful about the SPACES.

If you want to insert a space between two words, You’ve to use (,” “,) after selecting a cell in CONCATENATE Function.

OR

You can add spaces after those cell values which you’re going to join them, in there cells.

Look at the Example Below:

Concatenate Function

Concatenate Function

  • In example below, I’ve mixed and joined “Thank You”, “Please Pay” and Customer Name “Ali” and have used CONCATENATE with IF function.
  • In case if the PAID AMOUNT is less then TOTAL PRICE,  “Please Pay + Customer Name” will be visible.
  • and if the PAID AMOUNT is equal to 0, then “Thank You + Customer Name” will be visible.
Concatenate Function

Concatenate Function

WANT MORE EXCEL FUNCTIONS?

VIEW : MICROSOFT EXCEL FUNCTIONS BY CATEGORY

Best of Luck!


TAGS: , , , ,
About this Author
Raza Bayani

Ghulam Raza Bayani a Computer Engineer, Web Designer, Author and Blogger. I'm here to write for you and build up my own abilities, capacity & skills with Computer Technology.

Like us on Facebook
on Facebook
Raza Bayani

Follow me on Twitter
Follow @http://www.twitter.com/GRBayani on Twitter
Raza Bayani

7 Comments so far. Feel free to join this conversation.

  1. Raza SarwariMarch 8, 2015 at 8:40 pm - Reply

    Salam Dear Sir someone hacked my page and removed me from administrator and introducing himself from Islamic state, they are sharing harsh videos and deleting my post from my page. It can effect my career and insulting me. Kindly if you can do anything I will be great full to you..

    • Shais
      ShaisMarch 8, 2015 at 9:10 pm - Reply

      Hi Reza,
      Reset the password using your mobile number and change the settings.

      • Raza SarwariMarch 9, 2015 at 10:34 am - Reply

        Sir its facebook page and they removed me from admin and now the page is not in my control and I have change my facebook password but the facebook page always connected to the facebook account when they hacked my facebook they removed me from administrator. sir if you have any contact that we can talk about it quickly

  2. Raza Bayani
    Raza BayaniMarch 8, 2015 at 9:22 pm - Reply

    Let me know if you are talking about facebook? or any other page!

    • Raza SarwariMarch 9, 2015 at 10:33 am - Reply

      Sir its facebook page and they removed me from admin and now the page is not in my control and I have change my facebook password but the facebook page always connected to the facebook account when they hacked my facebook they removed me from administrator. sir if you have any contact that we can talk about it quickly

      • Raza Bayani
        Raza BayaniMarch 9, 2015 at 2:47 pm - Reply

        Leave a message on your timeline and mention that the page is hacked and not in your control. Ask your friends and fans to report the page, in case the reports reach the limit, facebook will block the page.
        and don’t worry that isn’t effective on your personality.

  3. Raza SarwariMarch 9, 2015 at 3:28 pm - Reply

    Sir the page likes reached 14 thousand, how many reports need to block? And is there any way to take it back?

Leave A Response