WPS Office

Free All-in-One Office Suite with PDF Editor

correct-icon

Edit Word, Excel, and PPT for FREE.

correct-icon

Read, edit, and convert PDFs with the powerful PDF toolkit.

correct-icon

Microsoft-like interface, easy to use.

Free download

Windows • MacOS • Linux • iOS • Android

banner

How to split cells in WPS Office Excel

July 31, 2023
15.1K Views

Are you still a green hand in using Excel? WPS Academy is definitely designed for you! After reading this free tutorial, you will quickly master how to split a cell in WPS Office Excel with 5 steps.  

When we want to split cells with data into multiple cells, we can use the Text to Columns function provided by WPS Office.

lSteps to split cells in WPS Office Excel

1. Open the document in WPS Spreadsheet.

2. Go to the Data tab, and click Text to Columns to activate the Convert Text to Columns Wizard dialog.

3. Check Delimited, and click theNext >button.

1.gif

4. At Delimiters, only check Comma and Space, and click Next >. In the Data preview area, we can the data have been split.

5. Click to set Destination to =$C$2, and click Finish.

2.gif

Consequently, the single-cell values are divided into multiple cells.

In today's tutorial, we introduce the technique to split a cell on Excel. Furthermore, WPS Academy provides you with plenty of helpful tutorials, enabling you to become a professional user. Visit us via the following links.

Quickly locate the name of the row and column where the cell is located | WPS Academy Free Office Courses

Wrap text in a cell | WPS Academy Free Office Courses

lWhat is WPS Office Spreadsheet?

WPS Office Spreadsheet is a module of WPS Office suite, the all-in-one office software considered as the best alternative to Microsoft office suite. WPS Office Spreadsheet not only covers all of the basic functions of Excel, but also enables advanced techniques for data cleaning and analyzing. The concise interface and clear classification of functions will definitely improve your work efficiency and productivity.

Find free Excel help and learning resources in WPS tutorials. WPS Spreadsheet tutorials for beginners cover lessons for Excel learning and how to use various Excel formulas, tables and charts for managing your school, work and family business process.

15 years of office industry experience, tech lover and copywriter. Follow me for product reviews, comparisons, and recommendations for new apps and software.