Joining text using formula in Microsoft Excel

In this article, we are going to learn how we can join the text by using formula and function in Microsoft Excel.

In Excel, we have built-in function that we use to join the text and cells. We have a formula to join the text or cells.

To join the several text strings with another text string, we use concatenate formula.

Using Concatenate Function

Let’s take an example and understand:-

We have name list data in range A1:C6. Column A contains First Name, Column B contains Middle name and Column C contains Last name. We need to join the Full name in a single cell.

image 1

 

To join the text with spaces, follow below mentioned steps:-

  • Select the cell D2 and write the formula.
  • =CONCATENATE(A2,” “,B2,” “,C2) Press Enter.

image 2

 

  • The function will join the name in a single cell with spaces.
  • Copy the same formula by pressing the key Ctrl+C on your keyboard and paste into the range D3:D6 by pressing the key Ctrl+V on your key board.

image 3

 

Using “&” in Formula

Now, follow below steps to join multiple text string with single text string:-

image 4

 

  • Enter the formula in Cell E2.
  • =A2&” “&B2&” “&C2
  • Press Enter.
  • Formula will join the text strings.

Formula Explanation:- We have selected cell A2 then “&” sign to add another string, then we have added space between inverted commas in order to provide space between strings.

Here’s the procedure we followed in this formula.

  • Copy the same formula in the range E3:E6.

image 5

 

In these ways, we can join several text strings with one string in Microsoft Excel by using the formula & functions.

Conclusion: – In Excel, we have various options to do one thing. Therefore, various problems can be resolved by using ‘Options’ and Formulas.

 

image 48

If you liked our blogs, share it with your friends on Facebook. And also you can follow us on Twitter and Facebook.
We would love to hear from you, do let us know how we can improve, complement or innovate our work and make it better for you. Write us at info@exceltip.com

 

Users are saying about us...

  1. “Greetings,

    I am trying to see if there is a way to join two different colums of text into on colum? I am trying to populate my web store with these products from my distributor. One colum has the product name such a ARG12 and then the second colum has “”noimage.gif”” but I changed “”noimage.gif”” to just “”.gif”” now if i could only find a way to merge or joing these two colums, then the image names would all be easily imported (there over 2000) and having to manually type a “”.gif”” after each one would take forever…There must be a way to merge two colums of text? or a way to easily do this so that i end up with ARG12.gif in one colum?

    Anyone?
    Thanks,

    -taylor reaume
    Loopwise.com
    tre@loopwise.com
    AIM Y! MSN loopwisechat

  2. “The easiest way to do this is in a new column enter the formula =a1&””.gif””
    Copy the formula down to the end of the range.
    When finished copy and paste special_values
    You now have the value from column A and the suffix.gif in text

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

Terms and Conditions of use

The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.

Visit Us On TwitterVisit Us On FacebookVisit Us On Google PlusVisit Us On Youtube