<div>
Ooops I meant to split the points. &nbsp;GIving 100 for the link and 400 for formula.<br />
<br />
Can a Moderator help here?<br />
<br />
Rowby
</div>


Ooops I meant to split the points.  GIving 100 for the link and 400 for formula.

Can a Moderator help here?

Rowby

<div>
I left a request for the Moderator to fix the point split.<br />
<br />
Rowby
</div>


I left a request for the Moderator to fix the point split.

Rowby

<div>
Good. &nbsp;Thanks to the Moderator for letting me correcting the point split.
</div>


Good.  Thanks to the Moderator for letting me correcting the point split.

<div>
<div class="content wysiwyg-content">
Hi<br />
<br />
Using Excel 2007<br />
<br />
I have a column of zip codes that are zip plus 4. &nbsp;I need a formula that will change it to just the regular zip.<br />
<br />

<pre><code id="code-8254826">Zip Code
93309-2156
93932-0446
92509-3600
93711-5770</code></pre>
<br />
The data can be numbers or text. &nbsp;<br />
<br />
I would like the result to be as follows.<br />
<br />

<pre><code id="code-10-27987363-1"></code></pre>
<pre><code id="code-8254827">Zip Code
93309
93932
92509</code></pre>
<br />
Thanks!<br />
<br />
Rowby
</div>
</div>


Hi

Using Excel 2007

I have a column of zip codes that are zip plus 4.  I need a formula that will change it to just the regular zip.



The data can be numbers or text.  

I would like the result to be as follows.

(CODE)

Thanks!

Rowby

Excel Converting Zip plus 4 to just 5 number zip

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