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.

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

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

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

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

6. EXCEL string splitting is completed

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!