Separation of compound names, within the name

[shimaa01234]

Can you separate the compound names in Arabic
Such as:
Abdel Rahman, Abdel Massih
Using the formula
Separation of compound names, within the name,
Name the compound so that, in a single column
And the rest, all in the name of a separate column
Like this table

Mohammed Abdel Rahman Bayoumi	Mohammed	Abdel Rahman	Bayoumi
Abdel Rahim Mustafa Tayeb	Abdel Rahim	Mustafa	Tayeb
Elias Abdel Massih Charles	Elias	Abdel Massih	Charles

<tbody>
</tbody>

 

[Peter_SSs]

Are you able to give a clearer set of examples? It is hard to see where cells start & stop. My signature block below has suggestions for that.

Also, you would need to give a clear set of guideline about how the names should be split.

Edit: Your table is a little clearer now you have edited it but how would we decide what is a compound name and what is not? Is it always "Abdel" followed by something?

 

[Special-K99]

There doesn't seem to be an exact pattern.

All names have 4 parts.
The 1st and 3rd names have two middle names but the 2nd name has two first names.
There's no way to distinguish between the 1st and 3rd type and the 2nd type.

 

[shimaa01234]

Compound names,
That begins with the word "Abdel"
And added to another word such as
Abdul Rahim Abdul Rahman, Abdullah ........ etc.
Abdul Rahim
Abdel Rahman
Abdullah
Abdel Massih
Name this one, not two parts

 

[shimaa01234]

I know it, is not easy
But if this issue is resolved
Save me a lot of time and effort
But I am sure, you can do this very easily
I am using this formula
= TRIM (MID (SUBSTITUTE ($ A1; ""; REPT (""; 99)); COLUMN (A1) * 99-98; 99))
To Mr. "Rick"
But did not give me the correct result, the compound names

 

[Peter_SSs]

Are you able to give a clearer set of examples?

.. say 10, together with the expected results?

 

[shimaa01234]

Possible, "Sir"
And possible be greater than 10
Such.
Abdel Rahman
Abdel Massih

 

[shimaa01234]

For more help
These are examples of more "compound names"
Such.
Nour El Din, Diaa Eddin, Zein El Din, Alaa El Din, Aly El Din, Saif Aldin, Gamal Eddin, Galal El Din, Kamal El Din, Bahaa El Din

 

[MAHMOUD-LEE]

I have a good idea
This can be overcome by placing a dot "." Or anything rather than the space between the "Name compound"
The formula is working well

 

[MAHMOUD-LEE]

Thank you