1、 First select the cells you want to column , Click the column under the data .
2、 Default separator , Click next , The data here is separated by commas , Click other , Enter the corresponding symbol , Click Next , Enter the select target area , That is to store the split content . Finally, click finish .
3、 It can also split the data of two columns in batch , Operation method and steps 2 The tutorial is the same .
That's through the disaggregation function , Split cell data into other cells . Have you learned this skill ? The technique you did in half an hour , The other guy's in two minutes , It is suggested to collect and study ~