How to Format Numbers in a Concatenate Function in Excel 2007

Written by theon weber
  • Share
  • Tweet
  • Share
  • Pin
  • Email
How to Format Numbers in a Concatenate Function in Excel 2007
The Concatenate function joins the contents of groups of cells. (number background image by kuhar from Fotolia.com)

Excel's Concatenate function inserts the contents of certain cells into other cells, arranging them as strings. The function's format allows you to blend variable cell contents with fixed strings that don't depend on the contents of other cells, as in the example below. Using numbers in concatenate functions is easy, as long as they're properly formatted.

Skill level:
Easy

Other People Are Reading

Instructions

  1. 1

    Click the cell in which you want to insert the concatenate function.

  2. 2

    Type the function in this format:

    CONCATENATE("This is the contents of cell A1: ", A1, ". And this is the contents of cell B2: ", B2, ".")

    Anything you put in quotes, including numbers, will be reproduced as you wrote it. Outside of quotes, strings (like A1 above) will be interpreted as cell numbers, and the concatenate function will fill in the contents of that cell. For example, if cell A1 contains the number "123," and B2 the number "456," the above function would produce:

    This is the contents of cell A1: 123. And this is the contents of cell B2: 456.

    Remember, if you want to use fixed numbers in a concatenate function, enclose them in quotes.

  3. 3

    Press "Enter" to complete the addition of the function.

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.