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?

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

Leave a Reply