Clean And Trim Data With These Functions

1 minute read Combine these 3 functions to completely clean your data: =TRIM(text) =CLEAN(text) =SUBSTITUTE(text,” “,””) The CLEAN function removes a range of non-printing characters, including line breaks, and returns “cleaned” text. The TRIM function then takes over to remove extra spaces and returns the final text. Note that CLEAN is not able to remove … Read more