Convert Zip+4 to Zip Standard

[bizybeaver]

I have a column with hundreds of zip+4.

I need to convert the Zip + 4 to a standard 5 digit Zip code.

They currently have a hyphen, which I saw a post that explained how t
get rid of that, but how can I tell Excel to delete, say the last
digits of a number?

Any help is greatly appreciated

 

[J.E. McGimpsey]

One way:

Say the zip+4's are in column D. In an empty column, say J, enter

J1: =LEFT(D1,5)

copy down as far as necessary.

Select column J. Copy. Select column D. Choose Edit/Paste Special,
selecting the Values radio button.

Clear column J.