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>

 

[shimaa01234]

Error occurs when you add a name to the name of the fourth division after the columns
Appears like this:

Abd Elaziz Ibrahim Abd Rahman Mohammed

Abd

Elaziz Ibrahim Rahman

Mohammed

<colgroup><col width="274"><col width="85"><col width="147"><col width="90"></colgroup><tbody>
</tbody>

I'm sorry, I know that the "compound names" difficult to be separated

 

[István Hirsch]

Error occurs when you add a name to the name of the fourth division after the columns
Appears like this:

Abd Elaziz Ibrahim Abd Rahman Mohammed

Abd

Elaziz Ibrahim Rahman

Mohammed

<tbody>
</tbody>

I'm sorry, I know that the "compound names" difficult to be separated

In the first column (let’s call it A) there are six words, but the sum of words in B-D is only five. Please always show the desired result.
In your last table ’Abd’ is alone in column B, but before ’Abd’ was followed by another word in column B, e.g. ’Abd Rahman’ in your post #14. What does this depend on?

 

[shimaa01234]

I do not mean to be separate "slave" to a single column
But this happened after add the name of the fourth "Mohammed" to "Abd Elaziz Ibrahim Abd Rahman"
So I want another formula in the fourth column to separate the name if "4 names"

 

[István Hirsch]

I do not mean to be separate "slave" to a single column
But this happened after add the name of the fourth "Mohammed" to "Abd Elaziz Ibrahim Abd Rahman"
So I want another formula in the fourth column to separate the name if "4 names"

New approach:

B1:
=IF(MIN(FIND({"Abd","Alaa"},A1&"AbdAlaa"))=1,TRIM(LEFT(SUBSTITUTE(A1," ",REPT(" ",99)),198)),TRIM(LEFT(SUBSTITUTE(A1," ",REPT(" ",99)),99)))

C1:
=LEFT(TRIM(SUBSTITUTE(A1,B1,"")),FIND(" ",TRIM(SUBSTITUTE(A1,B1,"")))-1)

D1:
=IF(LEN(TRIM(SUBSTITUTE(A1,B1&" "&C1,"")))-LEN(SUBSTITUTE(TRIM(SUBSTITUTE(A1,B1&" "&C1,""))," ",""))>1,TRIM(LEFT(SUBSTITUTE(TRIM(SUBSTITUTE(A1,B1&" "&C1,""))," ",REPT(" ",99)),198)),TRIM(SUBSTITUTE(A1,B1&" "&C1,"")))

E1:
=TRIM(SUBSTITUTE(A1,B1&" "&C1&" "&D1,""))

Excel Workbook
	A	B	C	D	E
1	Abd Rahman Samir Ali	Abd Rahman	Samir	Ali
2	Abd Allah Ibrahim Marzouki	Abd Allah	Ibrahim	Marzouki
3	Samira Syed Abd ElMomin	Samira	Syed	Abd ElMomin
4	Alaa ElDin Mohamed Ali	Alaa ElDin	Mohamed	Ali
5	Peter Michel Abd ElMassih	Peter	Michel	Abd ElMassih
6	Abd Elaziz Ibrahim Abd Elrahman	Abd Elaziz	Ibrahim	Abd Elrahman
7	Abd Elaziz Ibrahim Abd Elrahman Mohammed	Abd Elaziz	Ibrahim	Abd Elrahman	Mohammed
Sheet

 

[shimaa01234]

All beautiful words in the world, sent it to you
Because you are a wonderful person, and gentle
Thank you very much for this wonderful effort with me
Thank you to these formulas, smart and skilled
Now all the formulas work like magic

 

[István Hirsch]

You are welcome. Thank you for the feedback.

 

[shimaa01234]

I'm sorry again
When I write "2 composite name"
Such as "Abd ElRahman Abd ElAziz Mohammed Ibrahim"
The name appears in the table like this

Abd ElRahman Abd ElAziz Mohammed Ibrahim

Abd ElRahman

Abd

ElAziz Mohammed

Ibrahim

<colgroup><col width="296"><col width="97"><col width="77"><col width="124"><col width="146"></colgroup><tbody>
</tbody>

I'm really very sorry for that

 

[István Hirsch]

I'm sorry again
When I write "2 composite name"
Such as "Abd ElRahman Abd ElAziz Mohammed Ibrahim"
The name appears in the table like this

Abd ElRahman Abd ElAziz Mohammed Ibrahim

Abd ElRahman

Abd

ElAziz Mohammed

Ibrahim

<tbody>
</tbody>

I'm really very sorry for that

To make further work possible, please separate ’Abd ElRahman Abd ElAziz Mohammed Ibrahim’ showing the expected result and do the same with all the name-structures that the formulas given so far do not process correctly. I do not know these structures, so I can base my work only on the patterns you provide.

 

[shimaa01234]

Wonderful, Mister " Istvan"
God bless you

 

[shimaa01234]

First - I'm sorry for your trouble
Secondly - the expected result is:

Abd Elrahman Abd Elaziz Mohammed Ibrahim

Abd Elrahman

Abd Elaziz

Mohammed

Ibrahim

<colgroup><col><col><col><col><col></colgroup><tbody>
</tbody>