Does anyone have a macro that will clean all text within a worksheet without me having to insert he function clean(A1) etc and then copy and paste the results

Thanks

KP