In a single formula how to extract the First and the Last Name from a full personal name?

[Lacan]

Hi Guys,

In a single formula how to extract always the First and the Last Name from a full personal name?
Thanks in advance!

Fórmula Principal para o Ficheiro VDF.xlsm
	A	B	C	D	E	F	G	H
1
2
3				FULL NAME
4				AGUEDA HAYDEE DE JESUS DO ESPIRITO SANTO AFRICANO RAMOS
5
6				EXPECTED RESULTS
7				AGUEDA RAMOS
8
9				FORMULA
10
11
12
13
14
15
Folha11

 

[hagia_sofia]

Hello, one way to do it:

=TEXTBEFORE(D4," ",1)&" "&TEXTAFTER(D4," ",-1)

 

[Lacan]

Thank you very much @hagia_sofia

 

[Macropod]

No formula based on first & last words will work where you have a multi-word surname (e.g. Van der Hausen)