TECHNIG
Gateway for IT Experts and Tech Geeks

How to use CONCATENATE Function in Excel?

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.
  • =CONCATENATE(text1, [text2],[text3],...)
  • 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!

7 Comments
  1. Raza Sarwari says

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

    1. Shais says

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

      1. Raza Sarwari says

        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 says

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

    1. Raza Sarwari says

      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

      1. Raza Bayani says

        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 Sarwari says

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

Leave A Reply

Your email address will not be published.