How to set columns in excel

1. First open the Excel table, select the data to be divided into columns, and click the [Data] option in the menu bar

2. Select the column sorting option in the pop-up secondary menu, and then check [Delimiter]

3. Click Next, and then check [Others]. Enter the comma

4. Click Next and select [General] for the column data format

5. We need to To change the target area according to the actual situation, select the data area where you need to set the columns

6. Finally, click Finish.

Recommended tutorial: excel tutorial

The above is the detailed content of How to set columns in excel. For more information, please follow other related articles on the PHP Chinese website!