expression help

[userid128223]

I have below variable which will store following list.

vList variable:

Paris

Tokyo

New York

Expression:    ='(' & Replace(Trim(vList), chr(10), '|') & ')'

results: (Paris|Tokyo|New York)

How can i change the expression so that my results looks like below:

required results: ("Paris"|"Tokyo"|"New York")

[m_woolf · Accepted solution]

='("' & Replace(Trim(vList), chr(10), '"|"') & '")'