Browse » Home
Tuesday, November 15, 2011
How to Format Numbers in a Concatenate Function in Excel 2007
1. Click the cell in which you want to insert the concatenate function.
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. Press 'Enter' to complete the addition of the function.