split between arabic and english in one cell into two cell

I have a problem, how to split arabic and english text in one cell into two cell. for example the arabic and english text in cell A1, and I want the english text displayed in cell B1 and arabic text in cell C1. the example text was attached.
splitting between arabic and english character. thank's for helping

A B C
أكْثَريّة majority
أكْثَرِيّةٌ بَسِيطَة simple majority
أكْثَرِيّةٌ خاصّةٌ أو مُعَيّنَةٌ qualified majority
أكْثَرِيّةٌ ساحِقَة landslide, overwhelming majority
أكْثَرِيّةٌ مُطْلَقَة absolute majority
أكْثَرِيّةٌ نِسْبِيّة relative majority

vijay003. Welcome to the forum. Pls take a few minutes to read forum rules, because:

Your post does not comply eith rule 2 of our forum. Don't post a question in the thread of another member -- start your own. If you feel it's particularly relevant, provide a link to the other thread.

Unfortunately your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.

If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.

Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.

Hi.

It's a forum rule that you start your own thread, rather than "piggy-backing" on someone else's thread. This helps prevent massive confusion arising - which will happen if it is not clear which question is being answered. So please start your own thread and explain your own problem (make sure that, right from the start, you use a meaningful title (NOT things like "help needed" or "urgent problem"... think of the Google search terms that you would use to find the solution).

A picture is worth 1,000 words. An Excel sheet is worth 1,000 pictures. So, prepare a SMALL sample sheet (10-20 rows, not thousands!!!). Make sure there is enough data to demonstrate your need. Make sure your desired results are shown, mock them up manually if necessary. Remember to remove ALL confidential information first!!!


The yellow banner about sample worksheets, at the top of the screen tells you how to post a sheet here on the Forum.