How to add few blank space between YYYY and SOURCE ?

[paulyeo11]

Hi All

Below expression :-

='P&L Report (S$K)' & Chr(10)  & date(date#(Year(Today())-3,'YYYY'),'YYYY')   & SOURCE & '

Will display as :-

P&L Report (S$K)2014TDSS

i wish it display as :-

P&L Report (S$K)  2014  TDSS

Paul

[jwjackso]

I would think just adding spaces in the string would work:

='P&L Report (S$K) '& date(date#(Year(Today())-3,'YYYY'),'YYYY')&' 'SOURCE

Why are you using the Chr(10) and why is there a single quote at the end?

[vishsaggi · Accepted solution]

try this?

= 'P&L Report (S$K)' & Chr(32)  & date(date#(Year(Today())-3,'YYYY'),'YYYY') &  Chr(32) & SOURCE

[paulyeo11]

Hi Vish

Thank you it work fine.

Paul

[vishsaggi]

Yes it does work. Just one & is missing in your expression just before SOURCE.

= 'P&L Report (S$K) '& date(date#(Year(Today())-3,'YYYY'),'YYYY') & ' ' & SOURCE