<div>
Or, highlight the cell, go to the Data ribbon, click Text to Columns, select delimited, then use the comma as the separator. This will split the info into one cell for each item between commas.
</div>


<div>
<div class="content wysiwyg-content">
I have an address in the form of:<br />
<br />
8065 Elk Grove Florin Road, Sacramento, CA 95829<br />
<br />
I want to pull just the street number and name out. Basically everything to the left of the first comma. How can I pull this out?
</div>
</div>


I have an address in the form of:

8065 Elk Grove Florin Road, Sacramento, CA 95829

I want to pull just the street number and name out. Basically everything to the left of the first comma. How can I pull this out?

Pull street out of address

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