Extracting Intials from a name in a cell?

[Guest]

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

 

[Guest]

Thanks for the prompt response - works great

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

HTH
Jason
Atlanta, GA

 

[Guest]

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

HTH
Jason
Atlanta, GA

 

[Guest]

Thanks for the prompt response - works great

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