• Skip to main content
  • Skip to primary sidebar

Techbout

Technology Simplified.

  • Windows
  • iOS
  • Mac
  • Android
  • Office
Home » Office » How to Combine Text From Different Cells In Excel

How to Combine Text From Different Cells In Excel

By: Waseem Patwegar

Microsoft Excel makes it really easy to combine data from different cells into a single cell. You will find below the steps to combine Text from Different Cells in Excel.

Combine Text From Different Cells In Excel

Combine Text From Different Cells in Excel

If you are working in a job that requires data entry and analysis, you will often come across the need to combine text from different columns in to a single column in an Excel worksheet.

For example, let us assume that you have a list of addresses with City, Street and Postal code laying in different columns. In order to prepare a mailing list, you will have to combine the City, Street and Postal Code entries into a single entry.

Similarly, you may be required to generate a list of Full Names, data comprising of First Name, Middle Name and Last Names laying in different Excel Columns.

Both the above tasks can be easily accomplished using the “&” Operator and also by using the Concatenate Function.

1. Combine Text From Different Cells in Excel Using “&” Operator

The simplest way to combine text from different Cells into a single Cell in Excel is to make use of the “&” Operator.

1. First Select the Location where you want the combined Text to appear. In our case, we have selected Cell D3, as it lies immediately to the right of Columns containing the “First” and “Second” Names (See image below).

Combine Data in Cells using "&" Operator

2. Now, to combine the Text from Cell B3 and Cell C3, type =B3&C3 in Cell D3 and hit the Enter Key on the keyboard of your computer.

Once you hit the Enter Key, you will immediately see the combined data (B3+C3) in Cell D3. However, as you can see in the image below, there is no space between the First and Second name.

Combined Data With No Spacing Between the Data Items

3. To Add Space between the First and the Second Names, type = B3&” “&C3 in Cell D3 and press the Enter key on the keyboard of your computer.

Combine Data and Insert Space Using "&" Operator in Excel

You will now see a space between the First and Second Names (See image below).

Combined Text With Space Between Text Strings

Note: Any character that you write within the quotes will be rendered in the final output. This means that you can easily add space, comma, or anything else to the final output.

Also, there is no limit on the number of ampersands (&) that you can use in Microsoft Excel. You can use as many ampersands (&) as required to combine data from an unlimited number of Cells.

Combine Text From Different Cells in Excel Using Concatenate Function

Another popular Excel Function that can be used to combine text strings from different cells into a single cell is known as “Concatenate”.

The “Concatenate” Function in Excel joins text strings from different Cells into a single Cell and the Syntax of the Concatenate function is as follows:

CONCATENATE (text1, text2, … text_n)

text1, text2, etc. can be text strings, numbers or single-cell references.

To demonstrate the use of Concatenate Function, let us again take the simple case of Excel Worksheet having First and Second Names in different Columns.

1. First select the Location where you want the combined text data to appear. In our case, we have chosen Cell C4.

2. To combine the “First” and “Second” Names, type =Concatenate(A4,” “,B4) in Cell C4 and hit the Enter key on the keyboard of your computer.

Combine Text Strings Using Concatenate Function in Microsoft Excel

Note: In the above formula we are inserting a space between the First and Second names by including ” “ in the above formula.

3. Once you combine the data in the first cell, you can quickly combine all the remaining cells by dragging the formula down for all the remaining Cells.

Combine Text Strings Using Concatenate Function

Note: The Concatenate Function can be used to combine up to 255 strings containing a maximum of 8,192 characters.

Related
  • How to Transpose Columns to Rows in Excel
  • Easy Way to Remove Duplicate Entries in Excel

You May Also Like
    • Prevent Outlook From Adding Calendar Events
      How to Prevent Outlook From Adding Calendar Events
      • Show Developer Tab in Excel Ribbon Menu
        Add or Show Developer Tab in Excel Ribbon Menu
        • Set Out of Office Message in Microsoft Teams
          How to Set Out of Office Message in Microsoft Teams

Primary Sidebar



Gadget Guide

  • Should You Buy MacBook or Windows Laptop
  • Chromebook vs Windows Laptop
  • 12 Reasons to Switch to Chromebook
  • Kindle E-Reader Comparison
  • Best Asus Laptops Under 500




About | Privacy Policy | Disclosure | Terms | Contact
© 2023 Techbout.com · All Rights Reserved