Adam has an Excel datasource set up in his Klipfolio account. Column 1 of the datasource contains the names of new customers in the past month and Adam suspects that the entries of this column have leading and trailing blanks. What is the best function that Adam should use to remove the leading and trailing blanks?

Klipfolio Partner
  • CONCAT
  • SUBSTITUTE
  • URLDECODE
  • URLENCODE
  • None of the above

Leave a Reply

Your email address will not be published. Required fields are marked *