Articles with the tag:
Close
Changelog
Close
Try in the cloud
Try in the cloud

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.

  1. Select the cell with the content you want to split into separate cells.
  2. 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

  1. Select the cell or the cells within one column with the content you want to split into separate cells.
  2. Go to the Data tab located at the top toolbar.
  3. Click the Text to Columns Text to Columns icon.
  4. 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.

    delimiter type

  5. Click OK.
How to create a new document?
Close
Try now for free Try and make your decision No need to install anything
to see all the features in action
You Might Also Like This:
Close