• 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.

Seperate English text from arabic

Or try this shorter formula way:

1] In B2, copied down:

=LEFT(A2,-LOOKUP(,-FIND(" ",A2,ROW(A:A)))-1)

2] In C2, copied down:

=SUBSTITUTE(A2,B2,"")

1689153691677.png
 
You must log in or register to reply here.
Back
Top