This was how to sum cells with text and numbers in Excel. To wrap it up, adding numbers in Excel that are mixed with words is easy once you know how. With simple tricks like LEFT, FIND, or SUBSTITUTE, ...