• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

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

SACCHY

New Member
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 ريال سعودي.​
 

SACCHY

New Member
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
 

Attachments

bosco_yip

Excel Ninja
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))

77063
 
Top