<div>
<div class="content wysiwyg-content">
I have an address is the form of:<br />
<br />
8065 Elk Grove Florin Road, Sacramento, CA 95829<br />
<br />
I would like to pull the City out. It is always the part in between the two comma's. Any way to pull the city out?<br />
<br />
Chris
</div>
</div>


I have an address is the form of:

8065 Elk Grove Florin Road, Sacramento, CA 95829

I would like to pull the City out. It is always the part in between the two comma's. Any way to pull the city out?

Chris

Pull City 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.