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]

Names already written
I want to be separated in separate columns
Thank you very much because I actually have thought about it

 

[shimaa01234]

Any help, because I need this necessary

 

[Peter_SSs]

I'm not sure if I can help but to decide I had asked for a set of say 10 examples of names AND the expected results from those names. You haven't provided such a list, you just keep giving more examples of the compound names.

I would need to see the full names and the results after they have been split, and it needs to be clear which name(s) are in each result cell.

 

[shimaa01234]

I hope that these names help you
Thank you Mister "Peter", to help

Abd Rahman Samir Ali		Abd Rahman	Samir	Ali
Abd Allah Ibrahim Marzouki		Abd Allah	Ibrahim	Marzouki
Samira Syed Abd ElMomin		Samira	Syed	Abd ElMomin
Alaa ElDin Mohamed Ali		Alaa Eldin	Mohamed	Ali
Peter Michel Abd ElMassih		Peter	Michel	Abd ElMassih

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

 

[István Hirsch]

Try this as a first 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:

=TRIM(SUBSTITUTE(SUBSTITUTE(A1,B1,""),D1,""))

D1:

=IF(OR(TRIM(MID(SUBSTITUTE(A1," ",REPT(" ",99)),198,99))="Abd",TRIM(MID(SUBSTITUTE(A1," ",REPT(" ",99)),198,99))="Alaa"),TRIM(RIGHT(SUBSTITUTE(A1," ",REPT(" ",99)),198)),TRIM(RIGHT(SUBSTITUTE(A1," ",REPT(" ",99)),99)))

Excel Workbook
	A	B	C	D
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
Sheet

 

[shimaa01234]

You are wonderful
Formulas excellent
Thank you very much for this effort
But I have a request if possible!
You could make three formulas in one formula
Can be pulled in all the columns
Thank you again, Mr. "Istvan Hirsch"
But when the formula "2 compound name"
The result is not correct
Like "
Abd Elaziz Ibrahim Abd Elrahman

 

[shimaa01234]

Also appeared error
When there is a "2 compound name" consecutive
Like this:

Mohammed Abd elRahman Bayoumi	Mohammed	Abd elRahman	Bayoumi
Abdel Rahim Mustafa Abdel Rahim		Abdel Mustafa Abdel	Rahim
Abd Elaziz Ibrahim Abd Elrahman	Abd Elaziz	Ibrahim Abd	Elrahman

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

 

[István Hirsch]

D1 (corrected):

=IF(OR(TRIM(LEFT(RIGHT(SUBSTITUTE(A1," ",REPT(" ",99)),198),99))="Abd",TRIM(LEFT(RIGHT(SUBSTITUTE(A1," ",REPT(" ",99)),198),99))="Alaa"),TRIM(RIGHT(SUBSTITUTE(A1," ",REPT(" ",99)),198)),TRIM(RIGHT(SUBSTITUTE(A1," ",REPT(" ",99)),99)))

Excel Workbook
	A	B	C	D
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
Sheet

 

[shimaa01234]

Last request
If the name is a four names
Such as:
Abd Elaziz Ibrahim Abd Rahman Mohammed

 

[István Hirsch]

Last request
If the name is a four names
Such as:
Abd Elaziz Ibrahim Abd Rahman Mohammed

Please show the required result by separating e.g.:

Ab Elaziz * Ibrahim * Abd Rahman * Mohammed OR
Ab Elaziz * Ibrahim Abd * Rahman * Mohammed etc.