<div>
If one of the names doesn't have a comma, there will be an error. You can do:<br />
=IF(ISERROR(FIND(&quot;:&quot;,A1));<wbr />A1;LEFT(A1<wbr />,FIND(&quot;:&quot;,<wbr />A1)-1))
</div>


If one of the names doesn't have a comma, there will be an error. You can do:
=IF(ISERROR(FIND(":",A1));A1;LEFT(A1,FIND(":",A1)-1))

<div>
<div class="content wysiwyg-content">
I have a massive list of names<br />
<br />
Structured as<br />
<br />
Smith, John: Operations (LDN)<br />
<br />
I only want Smith, John<br />
<br />
Can i have formula that cuts just before the semi colon?<br />
<br />
All data is listed in Col A<br />
<br />
Thanks
</div>
</div>


I have a massive list of names

Structured as

Smith, John: Operations (LDN)

I only want Smith, John

Can i have formula that cuts just before the semi colon?

All data is listed in Col A

Thanks

Cut text

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