Hi there,
You will need to create a formula like the following
if instr({Field}," ") > 0 then
replace({Field}," ","") else
if instr({Field},"!") > 0 then
replace({Field},"!","") else
if instr({Field},"-") > 0 then
replace({Field},"-","") else
{field}
You will need to repeate each of the instr and replace statements for each of the punctuations you want to check for and remove.
HTH
Steve