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.