Tutorial on how to set the width of Excel to sort cells into columns

As in this example, the content in column A is required to be divided into columns according to a fixed width.

Click to select the cell range A1:A10, and then click the [Data]-[Column] option.

After the previous step, the system pops up the [Text Column Wizard - Step 1] dialog box. Check the [Fixed Width] option in the dialog box. After the settings are completed, click [ Next] button.

After the previous step, the system pops up the [Text Sorting Wizard - Step 2] dialog box. In the dialog box, click the position to be sorted, and it will appear in the data preview. The column-by-column effect is displayed. When finished, click the [Finish] button.

Return to the worksheet. Through the above steps, the contents in column A are divided into column A and column B. The result is as shown in the figure:

The above is the detailed content of Tutorial on how to set the width of Excel to sort cells into columns. For more information, please follow other related articles on the PHP Chinese website!