There are many formulas to add a comma after the first word in a cell. In case you have a list arranged across a column, you can replicate the formula across the list using the Fill option. Add a ...

Take advantage of relative cell references to add the same values to two different rows in Excel. Relative cell references create relationships between cells so that values entered in one cell are ...

REDUCE allows you to iterate through your data, building your result step-by-step, in the same way a loop operates in a ...

If you have a spreadsheet containing the stocks in a shop or something similar, and you need to count the comma-separated values in a single cell, here is how you can get the job done. There is a ...

Here's how to build smarter checklists in Excel using checkboxes, conditional formatting and task dependencies to help with multi-step processes. In my previous article in this series, I walked you ...