11 Replies Latest reply on Feb 9, 2016 6:52 AM by rickaltman

    Add an "and" to a list

    rickaltman

      I have a field that receives a bunch of first names from a portal, thanks to the List function. The result might look like this:

       

      Alice, Bill, Chuck

       

      However, I need for the list to read:

       

      Alice, Bill, and Chuck

       

       

      I need to find the last comma in the text and add an "and" to it. I have been messing around with the Position function stuffed inside of a Substitute function, but I can't get it right. Can someone help?

       

      FMPA14

       

       

      Rick A.
      Pleasanton CA