Formula to Extract Surname From String

[JamesA11]

Hi

I need to extract a collection of surnames from strings that look like the examples below:

Davidovich Fokina A. (Esp)
Dimitrov G. (Bul)
Carreno-Busta P. (Esp)

Some of the surnames are one word, some two words without a hyphen and others are two words with a hyphen.

To get the surnames I therefore need to extract the text to the left of the space before the initial. Is that possible?

Thanks

 

[FormR]

Hi, based on those examples, here is one option you can try.

Book3
	A	B
1	Davidovich Fokina A. (Esp)	Davidovich Fokina
2	Dimitrov G. (Bul)	Dimitrov
3	Carreno-Busta P. (Esp)	Carreno-Busta
Sheet1

Cell Formulas
Range	Formula
B1:B3	B1	=LEFT(A1,FIND(".",A1)-3)

 

[JamesA11]

Great, thanks FormR!