comment by Excel variable

[clovati]

Hi everybody!

In excel I created this comment:

that is (note the words that go on new line):

vCommentoValOrdini

Valore Ordini (Fonte: Ordini online)

then in UI I obtain correctly this in a sheet:

but in other sheet I have this wrong:

Any idea?

thank you!

[marcus_malinow]

Try this:

='Valore Ordini

' & $(vCommentoValOrdini)

[Anil_Babu_Samineni]

You must close with Single quotes and use like

='Display' & Variable

[clovati]

I tried this:

='$(vCommentoValOrdini)'

and worked...

[oscar_ortiz]

Cristina,

Sounds like you may want something like this:

='Valore Ordini'

& Chr(013) &

'$(vCommentoValOrdini)'

The Chr(013) is a carriage return.

Good luck

Oscar

[jmvilaplanap]

Hi

Try to put it into single quotes '$(Variable)' then will be treated as a string and not like a formula that need to be evaluated.

Regards