#1
|
|||
|
|||
special characters from calculated excel spreadsheeet not shown
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 |
#2
|
||||
|
||||
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] |
#3
|
|||
|
|||
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 |
#4
|
||||
|
||||
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] |
#5
|
|||
|
|||
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 |
#6
|
||||
|
||||
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] |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Special characters in Word | Peter Maggs | Word | 8 | 01-13-2017 02:41 PM |
Interpreting special characters as bullets and indentations | burry01 | Word | 1 | 01-18-2016 12:24 AM |
Macros and special characters. | oldzack | Word | 3 | 10-31-2011 04:16 AM |
Special Characters missing | timorrill | Word | 1 | 06-09-2009 11:34 PM |
special/escape/insertion characters in word | manojbmsce | Word | 0 | 09-25-2008 06:40 AM |