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:
Click the cell in which you want to insert the concatenate function.
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.
Press "Enter" to complete the addition of the function.
- 20 of the funniest online reviews ever
- 14 Biggest lies people tell in online dating sites
- Hilarious things Google thinks you're trying to search for