View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
RI Foodie RI Foodie is offline
external usenet poster
 
Posts: 1
Default How do I delete the +four didgets from a Zip Code Column?

I downloaded from a data base that has the Zip Code +4 (00000+0000) in a
single field. I have hundreds of line in this worksheet. How do I remove the
+0000 values inside all of the cells in the column?