The concatenate function may not be as well known as other common Excel features such as IF and VLOOKUP, but it’s still effective, even though it performs a more simple function in nature.

The example below is taken from Excel 2010. Click the FORMULAS tab in the Ribbon. Click TEXT in the Functions List group. Click CONCATENATE This will bring up a new dialogue box. See below.

Flow per Cell = 6300 g.p.d. / 3 Cells<BR><BR>Is there some formatting command I can use within the Concatenate function to format the "6300 g.p.d." so it includes the thousands separator ...

This poses a problem when you actually need to concatenate the double quotation marks themselves. However, Excel has a special character function that allows you to enter such marks. Open your ...

Doing so will eliminate the comma from the end of the list. You might be wondering about Excel’s CONCATENATE() function, but you must reference each cell individually and include the comma ...

If you use the formula =H11&H12 to concatenate these cells, the result comes back with the serial date (such as, Due Date: 39054). Check out the Microsoft Excel archive, and catch up on our most ...