Combining two formulas

[Welsh Mark]

I have a column of company names (column A) I use two formulas to help tidy these up

=TRIM(SUBSTITUTE(A1,CHAR(160),CHAR(32)))
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o>=CLEAN(SUBSTITUTE(b1,CHAR(127),CHAR(7)))
<o>Is there a way to combine these to operate on the same cell. Or are there any recomendations to any other features / formula's that may help me. </o>
<o></o>
<o>I basically just want to keep a single line of data of standard text and numbers and remove all strange characters/ carridge returns etc.</o>
</o>

 

[MDCurry]

From TRIM formula copy everything but equal sign.

In CLEAN formula highlight b1 and paste