View Single Post
  #1   Report Post  
galsaba
 
Posts: n/a
Default What function should I use to convert 43232- to 43232

On the zip codes on the column Zip are in the structure of:
nnnnn- (for example, "07444-") .
What would be the function to get rid of all these "-"?

On a differnt spreadsheet I have the zips as nnnnn-mmmm.
I want to keep the nnnnn only. What function should I use?

galsaba