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

convert last, first names to intials
 

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

convert last, first names to intials
 

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

--
HTH

Bob Phillips

(remove xxx from email address if mailing direct)

"Brian" wrote in message
...
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

convert last, first names to intials
 

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

"cha" wrote:

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

convert last, first names to intials
 

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

convert last, first names to intials
 

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



"Gary''s Student" wrote:

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