Thread: Zip Codes
View Single Post
  #1   Report Post  
Queen
 
Posts: n/a
Default Zip Codes

I have a list of names and addresses in Excel. Some of the zip codes are in
just the regular 5 digit zip code format and some are in the zip + 4 format.
I would like to eliminate the additional 4 digits off the zip codes that have
them without having to manually delete those numbers from each cell. Is this
possible?