<div>
It can be done with formula but you can also do it with text to column option using fix width option
</div>


It can be done with formula but you can also do it with text to column option using fix width option

<div>
Try<br />
=LEFT(A1,FIND(&quot;-&quot;,A1))<br />
<br />
assuming text is in A1
</div>


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

assuming text is in A1

<div>
This is better<br />
<br />
=LEFT(A1,FIND(&quot;-&quot;,A1)-1)<br />
<br />
It removes the -
</div>


This is better

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

It removes the -

<div>
Hey Roy... it cut off at the first &quot;-&quot; so it looks like this:<br />
<br />
New Call from <br />
<br />
JAMES DOE (428) 555
</div>


Hey Roy... it cut off at the first "-" so it looks like this:

New Call from

JAMES DOE (428) 555

<div>
here is my method <br />
<br />
=TRIM(MID(SUBSTITUTE($A1,&quot;<wbr />-&quot;,REPT(&quot; &quot;,99)),COLUMN(A1)*99-98,99<wbr />))&amp;&quot;-&quot;&amp;TRI<wbr />M(MID(SUBS<wbr />TITUTE(A1,<wbr />&quot;-&quot;,REPT(&quot;<wbr /> &quot;,99)),COLUMN(B1)*99-98,99<wbr />))
</div>


here is my method

=TRIM(MID(SUBSTITUTE($A1,"-",REPT(" ",99)),COLUMN(A1)*99-98,99))&"-"&TRIM(MID(SUBSTITUTE(A1,"-",REPT(" ",99)),COLUMN(B1)*99-98,99))

<div>
Thanks! I'll be posting a similar question next.
</div>


Thanks! I'll be posting a similar question next.

<div>
<div class="content wysiwyg-content">
I have a column of cells that are all exactly like the below information. In the column next to it, I want to delete everything after the first phone number. So delete the &quot;&nbsp;- You Have...&quot;<br />
<br />
How can I only include the &quot;New Call from JOHN DOE (428) 555-5555&quot;<br />
<br />
<br />
New Call from JOHN DOE (428) 555-5555 - You Have a New Call From: JOHN DOE (428) 555-5555 Received: Friday, June 19, 2015 at 08:35 PM To
</div>
</div>


I have a column of cells that are all exactly like the below information. In the column next to it, I want to delete everything after the first phone number. So delete the " - You Have..."

How can I only include the "New Call from JOHN DOE (428) 555-5555"


New Call from JOHN DOE (428) 555-5555 - You Have a New Call From: JOHN DOE (428) 555-5555 Received: Friday, June 19, 2015 at 08:35 PM To

Take out information in a cell

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