seperate text from different languages from one cell

hello,
I have a lot of cells with text in different languages in one cell, combined together.
Is there any way to seperate the text from one language and the other language to 2 different cells?

for example:
A1 : HAPPYשמחה

the outcome i would like:
A2 : HAPPY
A3 : שמחה

Thanks!!!

Ori

If by any chance your text is more or less regular, you can try your luck with Text to Columns feature, or use any of these functions: LEFT, MID, RIGHT. Also, depending on your text, you could try to add a separator like a comma or a space between the 2 languages using Find/Replace. After that you're more likely to use Text to Columns succesfully.

Originally Posted by AlKey

Her is another one you can try

for left part

=LEFT(A2,MAX(IFERROR(FIND(CHAR(ROW(A$65:A$122)),A2),"")))

for right part

=RIGHT(A2,LEN(A2)-MAX(IFERROR(FIND(CHAR(ROW(A$65:A$122)),A2),"")))

***Both array formulas must be entered by using key combination of CTRL+SHIFT+ENTER and not just ENTER

Row\Col	A	B	C
1	Mixed Text	Left Part	Right Part
2	universityאוניברסיטה	university	אוניברסיטה
3	bicycle אופניים	bicycle	אופניים
4	breakfastארוחת בוקר	breakfast	ארוחת בוקר
5	hospitalבית חולים	hospital	בית חולים
6	pharmacy בית מרקחת	pharmacy	בית מרקחת

It does not give correct result if the last character of the English text appears several times, such as universities gives univers (Find function will always find the first occurrence of the given letter).