convert last, first names to intials

[Brian]

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

 

[cha]

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

 

[Bob Phillips]

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

--
HTH

Bob Phillips

(remove xxx from email address if mailing direct)

 

[Brian]

No, lastname and firstname are in the same cell seperated by a comma

 

[Gary''s Student]

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

 

[Brian]

Thanks Gary"s Student - looks like that is what I need.