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

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

=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

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

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

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