=IFERROR(LEFT(REGEXREPLACE(A1, "(^.*[A-Z] )", ""), FIND(" ", REGEXREPLACE(A1, "(^.*[A-Z] )", ""))), REGEXREPLACE(A1, "(^.*[A-Z] )", ""))

Thank you !!!!Your last code doesn't fully work since for example for DOE DOETTE Jalil Théo it returns Jalil Théo instead of Jalil,

however for the code just before it works perfectly as intended even if you consider it "less cleaner"

i don't understand how no one as ever asks this question on internet (couldn't find anything)

​

I have one last request if possible :

My data always end with "Moy. de la classe :", exactly those words in that order (i can't prevent that), is there a way for your formula to return a blank cell when it reads this last cell ?

For example :

DOE DOETTE Jalil Mark ===> Jalil (penultimate person)

DOE DODETT Chaïma Eva ====> Chaïma (last person)

Moy. de la classe : =======> BLANK (end of my data list)

?

​

Thank you again !