Thread: special characters from calculated excel spreadsheeet not shown
View Single Post
 
Old 05-21-2018, 02:46 PM
macropod's Avatar
macropod macropod is offline Windows 7 64bit Office 2010 32bit
Administrator
  
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,467
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default
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]
Reply With Quote