I can't remember it there is a vba equivalent so try this

sub cleanitup()
for each cel in selection
cel.value=application.clean(cel)
next
end sub

--
Don Guillett
SalesAid Software

"JJ" wrote in message
...
Is there a way I can apply the clean function to my whole spreadsheet?