Excel: Combine text and formulas in a cell
Whenever I analyze data in Excel, I format the spreadsheet to make it easier to read. A little attention to fonts, boxes and shading can help people understand the key data faster.
One way to give yourself some flexibility with formatting is to combine text and the results of a formula in a single cell. Just use the “&” operator to concatenate the text and the formula.
Consider this formula:
="Quantity: "&SUM(A1:A20)
Enter it into a cell, press enter and (assuming you have numeric values in cells A1 through A20) it will present this result in a single cell:
Quantity: 23
That kind of output’s pretty handy when you want to create a worksheet in your spreadsheet that aggregates data from other sheets while keeping the formatting simple.
Now that I know concatentate is a real word, I will not bother playing editor. Other than that, I like the techie color and feel. It’s good all around.