convert last, first names to intials

Giganews Newsgroups
Subject: convert last, first names to intials
Posted by:  Brian
Date: Mon, 15 May 2006

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

Replies