Data Import & Export

How to Split an Excel Cell Without a Delimiter

Maira Mehtab Sep 22, 2026 868 views

Question details

The user needs to divide the contents of a single Excel cell into multiple columns at a specific character position without using common delimiters like commas or spaces.

Product: Excel
Device & OS: not provided
Scenario: Organizing or extracting parts of fixed-length text data (such as product codes or ID numbers) within a spreadsheet.
Observed behavior: The goal is to cleanly separate a text string into two or more adjacent cells based on a fixed character count instead of relying on a separating character.

Before you start

Determine the exact character position where the split needs to occur, and ensure you have inserted enough empty columns to the right of your target data to prevent overwriting existing cells.

Solution 1Recommended

Use the Text to Columns Wizard (Fixed Width)

The built-in Text to Columns wizard is the most straightforward way to split data visually without delimiters by inserting manual break lines.

This method is highly effective for splitting large batches of data where the text consistently follows a strict length or format, such as 10-digit phone numbers or standardized employee IDs.

Select the Target Cells

Highlight the cells or the entire column containing the data you want to split.

Open Text to Columns

Navigate to the Data tab on the top ribbon and click on the Text to Columns button.

Choose Fixed Width

In the wizard window, select the 'Fixed width' option and click Next.

Set Break Lines

Click inside the data preview window to place vertical break lines exactly where the text should divide. You can click and drag to move a line, or double-click to delete one.

Finish the Wizard

Click Next to select data formats for each column if needed, then click Finish to apply the split across the selected area.

Prevent Data Loss: The Text to Columns feature pushes split data into adjacent columns on the right. Always verify that these columns are empty before finishing the wizard.

Solution 2

Use LEFT and RIGHT Text Formulas

Formulas are ideal if your split position relies on a specific character count and you want to preserve the original combined data intact.

Efficient Data Processing

Split Excel Cells Effortlessly with WPS Spreadsheet

WPS Spreadsheet offers powerful and intuitive data management tools, including the Text to Columns wizard and comprehensive text formulas. Splitting fixed-width data is seamless and highly efficient.

1. Open Your Document: Launch WPS Spreadsheet and open the file containing the combined data.
2. Select Data: Highlight the specific cells or column you wish to split.
3. Split Using Fixed Width: Go to the Data tab, click Text to Columns, choose the Fixed width option, and set your break points to split the text.

100% compatible with Microsoft Excel formulas like LEFT, RIGHT, and LEN.Intuitive Text to Columns wizard for quick fixed-width splitting.Lightweight, fast, and completely free to use.Familiar user interface requiring zero learning curve.

microsoft office alternative - wps office

Frequently Asked Questions

How do I remove a break line I accidentally added in the Fixed Width wizard?

To remove an unwanted break line in the Text to Columns preview window, simply double-click on the specific line, and it will be deleted immediately.

Can I use the MID function to extract text from the middle of a cell?

Yes, the MID function is highly effective for splitting text without a delimiter when you need the middle portion. The syntax is =MID(cell, start_position, number_of_characters).

What happens if the text length varies but I use fixed-width splitting?

If the text length varies significantly, fixed-width splitting might cut words in half or yield inconsistent results. In these cases, it is recommended to either standardize your data format first or use advanced formula combinations like LEFT, RIGHT, FIND, or SEARCH.

Will splitting cells via Text to Columns overwrite my adjacent data?

Yes, the Text to Columns wizard places the split data into the columns directly to the right of your selected column. You must ensure those destination columns are blank before proceeding to avoid overwriting existing data.

Excel & Data Problems