Extracting Intials from a name in a cell?

Brian · May 31, 2005

Hi all,

Is there an easy way to extract JUST the initials of a name in a cell if the
name format is:

Cell A1 = Bob Smith

need Cell B1 = BS

Thanks

Brian

Brian · Jun 1, 2005

Thanks for the prompt response - works great

Jason Morin said:
=LEFT(A1)&MID(A1,FIND(" ",A1)+1,1)

HTH
Jason
Atlanta, GA

Jason Morin · Jun 1, 2005

=LEFT(A1)&MID(A1,FIND(" ",A1)+1,1)

HTH
Jason
Atlanta, GA

Brian · Jun 1, 2005

Thanks for the prompt response - works great

Peo Sjoblom said:
If thge name is like firstname space lastname
however with double names and initials and otyer attributes it becomes
complicated, but for your example

=LEFT(TRIM(A1))&MID(TRIM(A1),FIND(" ",TRIM(A1))+1,1)

will do

Regards,

Peo Sjoblom