You could add the TRUE argument to RANDARRAY() but because we’re pulling text, it won’t matter. Let’s work through the example shown in Figure C , where the input value in D2 is 6.

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

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, ...

Open the Excel sheet; Click on the Text Box icon; Select Text Box; Resize and add text to the box; Add bullets to your list, Alternatively, we can also do this via the Symbol Menu.