How to split cells

Introduction

If you uploaded a log file from a third party source where the cells are not divided into columns correctly or you need to form columns later based on the specific character, use the ONLYOFFICE Spreadsheet Editor tool designed to split cells quickly and effortlessly.

Step 1. Format your content (optional)

Splitting the cells requires delimiters, i.e. symbols that act as identifiers for the future split. If the cell does not have them, type them in manually as per the instructions below. If the delimiters are already set, please proceed to Step 2.

Select the cell with the content you want to split into separate cells.
Type in delimiters after each word or word combination (a comma, a semicolon, a colon, a tab, a space or any other symbol you need).

Step 2. Split the cell

Select the cell or the cells within one column with the content you want to split into separate cells.
Go to the Data tab located at the top toolbar.
Click the Text to Columns icon.
Choose the delimiter type according to the one used in the selected cell (a comma, a semicolon, a colon, a tab, a space). If the delimiter type is not in the list, choose the Other option and enter the symbol needed in the box to the right.
Click OK.

How to create a new document?

Try now for free Try and make your decision No need to install anything
to see all the features in action

Articles with the tag:

Changelog

Help Center

Editors User Guides

How to split cells

Introduction

Step 1. Format your content (optional)

Step 2. Split the cell