1 Reply Latest reply: Jun 16, 2016 8:59 AM by Viresh Kolagimath RSS

    nPrinting formula

    Viresh Kolagimath

      Hi Guys,

      I have tow colums like below and i am trying to create a formula in nPrinting to merge both the cells and get the concatenated value.

      I am getting the result but i need a space in between the first cell value and second cell value.

       

      Header 1Date
      Report Ending on 6/3/2016

       

      the formula looks like =Header 1 & Date(Date,"D-MMM") and the output is Report Ending on6/3/2016.

      But how get the space after the on and it should look like Report Ending on 6/3/2016.

       

      thanks,

      Viresh