<div>
In a formula, like this:<br />

<pre><code id="code-20-40373551-1">=LEFT(A1,FIND(&quot;,&quot;,A1,1)-1)</code></pre>
</div>


In a formula, like this:


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

<div>
<div class="content wysiwyg-content">
I have a data in a cell with the below format. How do I pull out just the street address? The part to the left of the comma:<br />
<br />
674 N Las Posas Rd, Camarillo, CA 93010
</div>
</div>


I have a data in a cell with the below format. How do I pull out just the street address? The part to the left of the comma:

674 N Las Posas Rd, Camarillo, CA 93010

Pull Street Address out of 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.