Home  >  Article  >  Topics  >  How to split string in excel?

How to split string in excel?

烟雨青岚
烟雨青岚Original
2020-06-23 11:20:0233866browse

How to split string in excel?

How to split a string in excel?

Method:

1. First, enter a set of data to split the string and select them all.

How to split string in excel?

2. Then find “Column” in the upper menu and click to select it.

How to split string in excel?

3. Then select "Delimiter" in the pop-up "Text Column Wizard" and next step.

How to split string in excel?

4. Then select "Space" in the "Delimiter" position and click Next.

How to split string in excel?

5. Then in the third step, select "Column Data Format", select "Text" and click "OK"

How to split string in excel?

6. EXCEL string splitting is completed

How to split string in excel?

Recommended tutorial: "excel tutorial"

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

Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn