Concatenate In Excel

Do you need to know how to use concatenate in Excel? Concatenate allows you to join two or more strings together, applying to several versions of Microsoft Excel, including XP, 2000, 2003, and 2007. This allows for either words, blank spaces, numbers, or cell references to be combined, with the only separation being a comma. 

The syntax (or wording) for using concatenate in Excel is = CONTATENATE (text 1, text 2, etc).

Here is how to use concatenate in Excel.

  1. First, open your copy of Microsoft Excel, either from the START menu or that of a desktop shortcut.
  2. Enter in the text you want in the first cell fields, such as the number '4' in A1 and the word 'hours' in B2.
  3. Click on the cell that you would like the results in, such as A2 or C1.
  4. Click on the FORMULA tab and then choose "Text Functions."
  5. Choose CONCATENATE from the list of options.
  6. On the text 1 line, type in what you want, such as "the concert will begin."
  7. On the text 2 line, enter a space.
  8. On the text 3 line, enter the text from A1.
  9. On the text 4 line, ener a space.
  10. On the text 5 line, enter the text from B2.
  11. Click OK.
  12. The completed sentence (concatenate) will then appear in whichever cell you requested and will read, "the concert will begin in 4 hours."

Learning about concatenate in Excel allows for greater functionality of the program, as well as learning more about the different ways in which to use a spreadsheet, making it an easy program to go to when you need to do more than just enter in numbers and formulas.

show comments

What Others Are Reading Right Now.