Ultimate Guide to Splitting Data in Excel

I have non English alphabets ( like Arabic/ Chinese) starting in various positions of the phrase. How to split them?
I thought we can convert them in to numerical and then split them if they are say less than specific number so would separate the non English characters…

My last name has 2 words in it and I have a friend who actually has 4 words in his last names. This is quite frequent in many languages. So I guess, TEXTAFTER with -1 as argument will not work in this case.

the video is really good but can you please provide us the practise file ?