If you have an Excel cell with content that you’d like to split over multiple cells, you can do this at any time. The only requirement is that there are enough free columns available (or cells if the division is only going to be applied to an individual cell). The number of free columns must always be equal to at least the number of values that are to be separated from the affected Excel cell. For instance, if you want to split content over three columns in total, you’ll need two free columns next to the first one.
In the following guide, we use a starting cell as an example that contains the three values “1”, “2”,and“3”, which have to be divided over three different columns. For the first step, you need to place separators between these three values. Tab stops, spaces, commas or semicolons (see our example) can be used for this purpose: