Data Import & Export

Split English and Arabic Text into Separate Excel Columns

Bushra ParveenBushra Parveen Nov 14, 2026 869 views

Question details

Separate English and Arabic text from one Excel cell into two columns when multiple spaces mark the boundary.

Split English and Arabic Text into Separate Excel Columns
Product
Microsoft Excel
Device & OS
not provided
Scenario
Each cell contains English text followed by Arabic text, with multiple spaces between the two sections.
Observed behavior
Splitting on a single space does not produce the desired English and Arabic columns.
Before you start

Check that the first sequence of two or more ordinary spaces in each cell is the boundary between the English and Arabic sections. Identify two empty columns for the results.

Solution 1Recommended

Use Excel formulas to split at consecutive spaces

Use this method when the first pair of consecutive spaces consistently marks the boundary.

1
Enter the English formula

If the original text is in A2, enter =TRIM(LEFT(A2,FIND(" ",A2)-1)) in B2.

2
Enter the Arabic formula

In C2, enter =TRIM(MID(A2,FIND(" ",A2)+2,LEN(A2))).

3
Fill down and check

Select B2:C2 and drag the fill handle down. Check that each row has English in column B and Arabic in column C.

Use Excel formulas to split at consecutive spaces
Check the separator: Rows without two consecutive ordinary spaces return an error. An earlier pair of spaces within the English text will also cause a split at the wrong point.
Split text in WPS Spreadsheets

Separate English and Arabic Text in WPS Spreadsheets

Use formulas in WPS Spreadsheets to split text at the first pair of consecutive spaces and place each language in its own column.

  1. 1. Open the workbook: Open WPS Spreadsheets and use File > Open to select your Excel workbook.
  2. 2. Extract the English text: If the source text is in A2, enter =TRIM(LEFT(A2,FIND(" ",A2)-1)) in B2.
  3. 3. Extract the Arabic text: Enter =TRIM(MID(A2,FIND(" ",A2)+2,LEN(A2))) in C2.
  4. 4. Fill and verify: Select B2:C2, drag the fill handle down, and check the results. The first pair of ordinary spaces must mark the intended boundary.
Separate language sections without splitting single spaces within phrasesOpen and edit Microsoft Excel XLSX filesFill formulas down across multiple rowsUse WPS Office for free with a familiar spreadsheet interface
microsoft office alternative - wps office

Frequently Asked Questions

Why not split on every space?

English or Arabic phrases can contain single spaces, so splitting on every space can create extra columns. The formula method instead finds the first pair of consecutive spaces.

Why does the formula return an error?

FIND(" ",A2) returns an error if A2 does not contain two consecutive ordinary spaces. Check the separator in the source cell and confirm the formula references the correct row.

Can I turn the formula results into plain text?

Yes. In Excel, copy the result cells, then use Home > Paste > Values to paste the displayed text without the formulas.

Why did Word leave some rows unchanged?

The wildcard pattern requires an English letter, at least two ordinary spaces, and an Arabic character in the specified range. Punctuation, a different character, or another kind of space at the boundary can prevent a match.