<div>
Find the first name in a string:<br />
<br />
&nbsp; &nbsp;=LEFT(A1,FIND(&quot; &quot;,A1)-1)<br />
<br />
Find the last name in a string containing only two names:<br />
<br />
&nbsp; &nbsp;=MID(A1,FIND(&quot; &quot;,A1)+1,999)<br />
<br />
Kevin
</div>


Find the first name in a string:

   =LEFT(A1,FIND(" ",A1)-1)

Find the last name in a string containing only two names:

   =MID(A1,FIND(" ",A1)+1,999)

Kevin

<div>
If you have that data in A1 then you can get the first word in B1 with this formula<br />
<br />
=LEFT(A1,FIND(&quot; &quot;,A1)-1)<br />
<br />
and in C1<br />
<br />
=REPLACE(A1,1,FIND(&quot; &quot;,A1),&quot;&quot;)<br />
<br />
regards,barry
</div>


If you have that data in A1 then you can get the first word in B1 with this formula

=LEFT(A1,FIND(" ",A1)-1)

and in C1

=REPLACE(A1,1,FIND(" ",A1),"")

regards,barry

<div>
<div class="content wysiwyg-content">
Hi is there a way to split a name in Excel 2007. so happy exchange i need in one cell happy and exchange in another cell in excel.<br />
<br />

</div>
</div>


Hi is there a way to split a name in Excel 2007. so happy exchange i need in one cell happy and exchange in another cell in excel.



EXCEL 2007

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.