Formating Zip Codes

[DBFIN]

The zip code field includes 5 numbers plus a dash which is followed by 4 numbers. I want to use the format function to reformat the zip code field so the dash is removed and the result includes only 9 numbers. How can I do this ?

ZIP CODE1 = 53918-6432
ZIP CODE2 = 539186432

 

[pbaldy]

I would simply use the Replace function to get rid of the dash.

 

[DBFIN]

That worked great. Thank you.