English/Arabic words together in single cell, how to placed it on top of other cells with English word automatically

[SACCHY]

Electric Bill​

This is monthly Bill هذا فاتورة شهرية​

I want to have chicken burger​

The cost for Burger is 30 SAR. تكلفة برجر 30 ريال سعودي.​

how much is Petrol Price​

Total cost of Items is 500 SAR. التكلفة الإجمالية للعناصر 500 ريال سعودي.​

 

[vletm]

SACCHY
Could You send an Excel-file, which You have some sample data?
and
someway shown Your expected results?

 

[SACCHY]

Here the sample excel file, we can see some cell with only English words and some with Both English and Arabic, need to arrange all cell with English
and Arabic on top of the cell with only English words

 

[vletm]

SACCHY
Did You miss those Your expected results?

 

[bosco_yip]

Guessing..... and give you 2 formulas option

1] In B4, formula 1 copied down :

=LEFT(A4,FIND("%",ENCODEURL(SUBSTITUTE(A4," ","A")))-1)

or,

In C4, formula 2 copied down :

=REPLACE(A4,FIND("%",ENCODEURL(SUBSTITUTE(A4," ","A"))),1,CHAR(10))