I'm having trouble importing a file which has the odd double quotation mark dotted around the xls file. eg T-shirt, "logo" (M). The quotation mark messes up the import and I've tried using
Substitute (field;["\"";""];["( ";"("];[") ";")"];[" ";" "];[" ";" "];[".";""];[",";""];["-";" "];[".";"...