How to Merge Text From Two Columns Into One in Microsoft Excel

Written by chance e. gartneer
  • Share
  • Tweet
  • Share
  • Pin
  • Email
How to Merge Text From Two Columns Into One in Microsoft Excel
More columns of individual data creates an easier managed and understood spreadsheet. (number background image by kuhar from Fotolia.com)

"The devil is in the details." How true of composing a an Excel spreadsheet. Text used for one part may or may not be used for another. That is why it is better to break down the text into the smallest permissible part and merge that part with other text when needed. This leads to both easier management and a better understanding of an Excel spreadsheet.

Skill level:
Easy

Other People Are Reading

Instructions

  1. 1

    Click on the spreadsheet cell in which you would like to put the merged text.

  2. 2

    Click on the "Toolbox" icon in the header above the worksheet. It is located between the "Gallery" icon and the "Zoom" box, third from the end. The "Toolbox" will appear in the upper right hand corner of the screen.

  3. 3

    Click on the "Formula Builder" tab in the "Toolbox." It is the third tab labelled "fx" in the header.

  4. 4

    Type "concatenate" into the search box that appears under the header of the "Toolbox." Double click on the "concatenate" result underneath the search box. A shaded box will appear at the bottom.

  5. 5

    Enter the location of the first text that you want to merge into the box titled "text1." Type "A1" if the text that you would like to enter is in cell A1. You can also first click on the empty box next to "text1" and then click on the cell that you want to enter.

  6. 6

    Enter the desired cell into "text2" box. If you would like to merge more than two sources of text, then click on the "+" at the end of the line. If you would like to subtract a source, then click "-". When finished, press the Enter key.

Tips and warnings

  • Be careful to not go overboard with inputting a series of text inputs. You may never find where you made your mistake.

Don't Miss

Filter:
  • All types
  • Articles
  • Slideshows
  • Videos
Sort:
  • Most relevant
  • Most popular
  • Most recent

No articles available

No slideshows available

No videos available

By using the eHow.co.uk site, you consent to the use of cookies. For more information, please see our Cookie policy.