Here is a cell formula that will do that:
=CONCATENATE(LEFT(A1,1),MID(A1,FIND(" ",A1,1)+1,1))

Mike F
"Gordon" wrote in message
...
Hi...

I'm looking for code that will convert a column of first and surnames to
an
adjacant column of initials. eg. column A says Bill Smith, I want column B
to
say BS. This should apply to any name of any length...

Thanks in advance...

Gordon.