how to extract initials from first two words in a name (google spreadsheet)

[omcsarayar]

Hi everyone,

I have attached a link to a sample file in google spreadsheet which contains Names. I need to extract the initials from only the first two words in the name.

for example:
George William Norris Smith = GW

I have tried several methods and I am not able to get the right formula. Kindly help on this.

Sample

Sheet1 Name,Initials (Only First Two Word) George William Norris Smith Damian Francis Joan Clifford James Lee Hailey Cleo Virginia Lawson Tiffany Havannah Frederick Kevin Smith

docs.google.com

 

[RoryA]

=arrayformula(left(join("",left(split(A2," "),1)),2))
should work.

 

[omcsarayar]

=arrayformula(left(join("",left(split(A2," "),1)),2))
should work.

thankyouu so much

 

[RoryA]

Glad we could help.