2 Replies Latest reply: Mar 6, 2012 11:55 PM by Celambarasan Adhimulam RSS

    String List expression

    Rob Wunderlich

      Can anyone come up with an expression (no script solutions) to convert this list:

       

          A, B C,   D

       

      into

       

          'A','B C','D'

       

      This kinda works:

       

      =chr(39) & replace(mytext',',', chr(39) & ',' & chr(39)) & chr(39)

       

      Except it doesn't remove leading and trailing spaces from each element.

       

      Thanks,

      Rob