=LEFT(A2)&MID(A2,FIND(", ",A2),3)

--
HTH

Bob Phillips

(remove xxx from email address if mailing direct)

"Brian" wrote in message
...
Hi all,

Is there an easy way to convert the following cell (lastname, firstname)
to
(lastinitial, firstinitial)

e.g.

Smith, John to S, J

Thanks

Brian