View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Brian
 
Posts: n/a
Default convert last, first names to intials

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