Are lastname, firstname in separate cells. If yes use LEFT formula

"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