software

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

quot;Brianquot; wrote:

gt; Hi all,
gt;
gt; Is there an easy way to convert the following cell (lastname, firstname) to
gt; (lastinitial, firstinitial)
gt;
gt; e.g.
gt;
gt; Smith, John to S, J
gt;
gt; Thanks
gt;
gt; Brian

=LEFT(A2)amp;MID(A2,FIND(quot;, quot;,A2),3)

--
HTH

Bob Phillips

(remove xxx from email address if mailing direct)

quot;Brianquot; gt; wrote in message
news
gt; Hi all,
gt;
gt; Is there an easy way to convert the following cell (lastname, firstname)
to
gt; (lastinitial, firstinitial)
gt;
gt; e.g.
gt;
gt; Smith, John to S, J
gt;
gt; Thanks
gt;
gt; Brian
No, lastname and firstname are in the same cell seperated by a comma

quot;chaquot; wrote:

gt; Are lastname, firstname in separate cells. If yes use LEFT formula
gt;
gt; quot;Brianquot; wrote:
gt;
gt; gt; Hi all,
gt; gt;
gt; gt; Is there an easy way to convert the following cell (lastname, firstname) to
gt; gt; (lastinitial, firstinitial)
gt; gt;
gt; gt; e.g.
gt; gt;
gt; gt; Smith, John to S, J
gt; gt;
gt; gt; Thanks
gt; gt;
gt; gt; Brian

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

--
Gary's Studentquot;Brianquot; wrote:

gt; Hi all,
gt;
gt; Is there an easy way to convert the following cell (lastname, firstname) to
gt; (lastinitial, firstinitial)
gt;
gt; e.g.
gt;
gt; Smith, John to S, J
gt;
gt; Thanks
gt;
gt; Brian

Thanks Garyquot;s Student - looks like that is what I need.
quot;Gary''s Studentquot; wrote:

gt; If Smith, John is in B3 then:
gt; =LEFT(B3,1) amp; MID(B3,FIND(quot;,quot;,B3,1),3) will display:
gt; S, J
gt;
gt; --
gt; Gary's Student
gt;
gt;
gt; quot;Brianquot; wrote:
gt;
gt; gt; Hi all,
gt; gt;
gt; gt; Is there an easy way to convert the following cell (lastname, firstname) to
gt; gt; (lastinitial, firstinitial)
gt; gt;
gt; gt; e.g.
gt; gt;
gt; gt; Smith, John to S, J
gt; gt;
gt; gt; Thanks
gt; gt;
gt; gt; Brian