R Ritaam New Member Mar 3, 2022 #1 I have in column A, names of company, some of them are written in english letter and the other in arabic letter, I need to put in column B, all the english name and in column c the arabic name. How can I do it??
I have in column A, names of company, some of them are written in english letter and the other in arabic letter, I need to put in column B, all the english name and in column c the arabic name. How can I do it??
B bosco_yip Excel Ninja Mar 3, 2022 #2 Try, 1] In B2, formula copied down : =IF(LEFT(ENCODEURL(A2))<>"%",A2,"") 2] In C2, formula copied down : =IF(LEFT(ENCODEURL(A2))="%",A2,"") Last edited: Mar 3, 2022
Try, 1] In B2, formula copied down : =IF(LEFT(ENCODEURL(A2))<>"%",A2,"") 2] In C2, formula copied down : =IF(LEFT(ENCODEURL(A2))="%",A2,"")
