How to operate excel column splitting?
1. The following set of dates is what we want to divide into years, months, and days. First select this set of dates.
#2. Select data in the excel menu and click Sort Columns.
3. In the text column interface, we select the first delimiter and click Next.
4. Check Other in the delimiter, enter the small horizontal bar "-" between the dates in the small box on the right, and continue to the next step. .
5. This interface is used to select the format to be listed. We can use the default here and click Finish.
# 6. See that it is divided into three columns, namely year, month and day. But the year data seems wrong because it still uses the original date format.
#7. Then select the first column and change the format to regular.
Recommended tutorial: "excel tutorial"
The above is the detailed content of How to do column sorting in excel?. For more information, please follow other related articles on the PHP Chinese website!