How Excel cancels automatic parsing

Source: Internet
Author: User

1, open a new form, the data copy paste in, then you will see the left and right side of this line is two vertical lines, which is the success of the operation of the expression.

2, find the menu above the table, find the Data menu, point to go in, find the breakdown command.

3, click on the column, will pop up a dialog box, "Text Column Wizard, one of the steps" and follow the instructions here to proceed to the next step.

4, click Next, you will see the text of the second step of the wizard to the dialog box, then you can clearly see the breakdown of some of the identification.

5, remove the other front box in the Check and back box "/", and follow the wizard's prompts to click on the next step.

6, then see the picture as shown, this is also the last step, you will see the dialog box in the lower right corner of a certain button, click OK. So it's done.

Related Article

E-Commerce Solutions

Leverage the same tools powering the Alibaba Ecosystem

Learn more >

11.11 Big Sale for Cloud

Get Unbeatable Offers with up to 90% Off,Oct.24-Nov.13 (UTC+8)

Get It Now >

Alibaba Cloud Free Trial

Learn and experience the power of Alibaba Cloud with a free trial worth $300-1200 USD

Learn more >

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.