string representaion with single quotes

[Kushal_Chawda]

Dear QV Experts,

I have one Field having values A,B,C.... Some where I need to show these values by comma separated which I am able to do it with concat function as : Concat(Field,',')

Issue is: I want to display value as..  'A','B','C'.....(with single quotes)

Please let me know the work around

[lironbaram · Accepted solution]

you can use this formula

=chr(39) & Concat(Key,chr(39) & ',' & chr(39)) & chr(39)