Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
i have scenario where i have to concatenate filed with some text.
i have "region" a filed and i am trying like below,
=REGION&' (Including Consumer)'
this is working fine but this is generating one more extra line as below.
thanks in advance.
Modify your expression like this:
=if(len(REGION) > 0, REGION & ' (Including Consumer)')
-Rob
May be try this
=If(Len(Trim(REGION)) > 0, REGION & ' (Including Consumer)')