1. B

    Part text, part variable in a cell

    I am using Excel 2010. In cell B26, I want it to read "The total is ..", followed by a variable picked up from cell F4. The variable has to be included in cell B26. It's annoying, because 10 or 15 years ago I knew how to do this, but now I can't remember. I tried searching help, but...