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

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



"Brian" wrote:

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

Thanks for the prompt response - works great

"Jason Morin" wrote:

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

HTH
Jason
Atlanta, GA

"Brian" wrote:

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

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

HTH
Jason
Atlanta, GA

"Brian" wrote:

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

Thanks for the prompt response - works great

"Peo Sjoblom" wrote:

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



"Brian" wrote:

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