Concatenate ' & Value & '

[#1]

Hi,

Was trying to have a text value using concatenate operator -"&"

If Value = ABCD

and I want it to show like 'ABCD'

How do I do this ? if i do ='''&'ABCD'&''' it does not work.

Thanks,

Chinmay

[maneshkhottcpl]

Hi,

Use the

=

chr(39) & 'ABCD' & chr(39)

to print 'ABCD'

Thaks

Manesh