<div>
=IFERROR(LEFT(A1,FIND(&quot; &quot;,A1,FIND(&quot;,&quot;,A1)+2)),A1)
</div>


=IFERROR(LEFT(A1,FIND(" ",A1,FIND(",",A1)+2)),A1)

Formulas.png

Results.png

<div>
The suggested formula requires Excel 2007 or later (for IFERROR). It is looking for a space following a comma. The comma may be followed by a single space (or not).
</div>


The suggested formula requires Excel 2007 or later (for IFERROR). It is looking for a space following a comma. The comma may be followed by a single space (or not).

<div>
<div class="content wysiwyg-content">
I have this huge excel spreadsheet with names. I only want to extract the first and last names.<br />
For example it looks like this:<br />
Brown, John C.<br />
Hugo, Armstrong K<br />
Matto, Sam<br />
Mellow, vickie<br />
Smith-Dorr, Frances<br />
Lim, Fred J.<br />
<br />
And I would like the following:<br />
Brown, John <br />
Hugo, Armstrong <br />
Matto, Sam<br />
Mellow, vickie<br />
Smith-Dorr, Frances<br />
Lim, Fred <br />
<br />
Thanks
</div>
</div>


I have this huge excel spreadsheet with names. I only want to extract the first and last names.
For example it looks like this:
Brown, John C.
Hugo, Armstrong K
Matto, Sam
Mellow, vickie
Smith-Dorr, Frances
Lim, Fred J.

And I would like the following:
Brown, John 
Hugo, Armstrong 
Matto, Sam
Mellow, vickie
Smith-Dorr, Frances
Lim, Fred 

Thanks

Excel 2010 extract

Microsoft applications include a variety of software programs, including development and digital authoring programs (Expression and Media Center), educational programs, Internet software, including Essentials, Skype and the Live family, anti-virus, productivity applications and suites like Office, Excel, Word, Outlook, Access and PowerPoint, video games and server applications such as Exchange, SharePoint, IIS and Virtual Server.