<div>
If your names are in column a, starting in A2, you can strip off everything space and after using:<br />
<br />
=LEFT(A2,IFERROR(FIND(&quot; &quot;,A2)-1,LEN(A2)))<br />
<br />
and copy down<br />
<br />
Dave
</div>


If your names are in column a, starting in A2, you can strip off everything space and after using:

=LEFT(A2,IFERROR(FIND(" ",A2)-1,LEN(A2)))

and copy down

Dave

<div>
Perfect for the part of the question, how about the second? &nbsp;Thanks!!
</div>


Perfect for the part of the question, how about the second?  Thanks!!

<div>
<div class="content wysiwyg-content">
In Excel 2010 i have a colum that has names like Mike, Mike E. Mike E. Jones, etc &nbsp;i would like to strip off everything after a space, if a space does not exsist to use what is in there. &nbsp;<br />
Robert &nbsp;F<br />
Michael E. &nbsp;&quot;Mike&quot;<br />
Maryeann<br />
Stephen<br />
<br />
So in this example it would return a Robert, Michael, Maryeann, Stephen in the new column. &nbsp;Also, I want to combine 3 columns into one new one only using the first 4 characters in the last column. &nbsp;Example:<br />
Bolan &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Jared &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;19890705<br />
<br />
So the new column would contain: bolanJared1989
</div>
</div>


In Excel 2010 i have a colum that has names like Mike, Mike E. Mike E. Jones, etc  i would like to strip off everything after a space, if a space does not exsist to use what is in there.  
Robert  F
Michael E.  "Mike"
Maryeann
Stephen

So in this example it would return a Robert, Michael, Maryeann, Stephen in the new column.  Also, I want to combine 3 columns into one new one only using the first 4 characters in the last column.  Example:
Bolan	Jared	19890705

So the new column would contain: bolanJared1989

Excel

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