Split English and Arabic Text into Separate Excel Columns
Question details
Separate English and Arabic text from one Excel cell into two columns when multiple spaces mark the boundary.

- 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.
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.
Use Excel formulas to split at consecutive spaces
Use this method when the first pair of consecutive spaces consistently marks the boundary.
If the original text is in A2, enter =TRIM(LEFT(A2,FIND(" ",A2)-1)) in B2.
In C2, enter =TRIM(MID(A2,FIND(" ",A2)+2,LEN(A2))).
Select B2:C2 and drag the fill handle down. Check that each row has English in column B and Arabic in column C.

Insert tabs at the language boundary with Word
Use Word wildcard search to replace spaces between an English letter and an Arabic letter with a tab.
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. Open the workbook: Open WPS Spreadsheets and use File > Open to select your Excel workbook.
- 2. Extract the English text: If the source text is in A2, enter =TRIM(LEFT(A2,FIND(" ",A2)-1)) in B2.
- 3. Extract the Arabic text: Enter =TRIM(MID(A2,FIND(" ",A2)+2,LEN(A2))) in C2.
- 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.

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.




