How to Add the Difference Range In Excel. The simplest way to add cells in Microsoft Excel is using the plus operator, such as "=A1+A2," but that method fails when adding different ranges.

Adding a text to a cell in Excel using Formula requires use of ampersand operator, CONCAT function, or the LEFT, RIGHT, and LEN functions.