our alphabet uses special chracters such as č,š,ž.
i have a column with formula: =[@[POST NR]]&" "&[@POST NAME]
if post name contains any of the above characters they are shown as "_" in my word document using mail merge.
if the data in that column is hard writen it is fine. but it doesnt work when it is combined or calculated.
also tried =CONCATENATE([@[POST NR]];" ";[@POST NAME]) formula with the same result.
tried one cell to format as "general" and as "text" in excel spreadsheet with the same result