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 1 | Date |
|---|
| 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
