Another way to split data into multiple columns is to use some of Microsoft Excel's functions. If you choose this route, remember that the split values will be linked to the original values, meaning ...

Excel's PIVOTBY function allows you to group your figures without needing to recreate your data in a PivotTable. What's more, ...

You can add text to a cell in Microsoft Excel the traditional way by simply typing, but there are other ways to get the job done. For example, you can use a formula, or even a function to ...

Define & use names in Excel formulas. You can define a name for a cell range, function, constant, or table and once you become familiar with the technique, you can easily update, audit or manage ...