If Smith, John is in B3 then:
=LEFT(B3,1) & MID(B3,FIND(",",B3,1),3) will display:
S, J

--
Gary's Student


"Brian" wrote:

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