open_in_new content_copy
=TRIM(CLEAN(SUBSTITUTE(A1,CHAR(160)," ")))
open_in_new MORE content_copy COPY

@zscherrer at thiscodeWorks.com