Using the Text to Columns Tool One way to split data into multiple columns in Microsoft Excel is to use the built-in Text To Columns tool.

In Microsoft Excel, you are not just able to count characters in a single/multiple cell, but also specific characters in a cell or range of cells.

If you want to display multiple subtotals in your Microsoft Excel PivotTables, learn how to use a hard-to-find setting.