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