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

It is strange that the Mac mailmerge converter won't see the characters if they're the result of a formula. That said, since the characters seem to be recognised when they're not the result of a formula, a workaround might be to copy the data and paste it on another sheet using Paste Special>Values to delete the formulae, then use that sheet for the merge.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

im adding clients in that sheet all the time.
needing to special paste data every time before i create a new documents looses its purpose

I appreciate that, but it's also apparent the Mac mailmerge converter doesn't handle the characters correctly if they're the result of a formula. The alternative to using a separate worksheet without formulae is to use mergefields that point to whatever [@POST NR] and [@POST NAME] point to.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

the whole proces: im using 3 columns. POST NR, POST NAME, [POST NR]]&" "&[@POST NAME]. first 2 are for the clients living address. the last one is for a property at which they might not live. if they do the formula gives me the address already. if they dont, i have to change that address.
looks like the best option will be to just loose the formula and write the address in every time.
thanks anyway

It's not apparent from your last post where the "property at which they might not live" comes from and how that relates to [POST NR]]&" "&[@POST NAME]. Perhaps you could attach a trimmed-down copy of your workbook with some representative data plus your mailmerge main document to a post (delete/obfuscate anything sensitive). That way I might be able to suggest a way to achieve the desired result via field coding in Word rather than via formulae in Excel.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]