A basic formula might look like this: =A2+B2. This basically tells Excel to add the number in cell A2 to the number in cell B2, and then show the result in the cell where you typed the formula.

Before LAMBDA was introduced to Excel, you'd need to know how to use VBA or macros to create your own function. However, ...

We can use two functions to add a prefix to multiple (or all) entries across a column. The first one is using the & operator, and the second is using the CONCATENATE function. Where <prefix> is ...