Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Word / Mailmerge and Fax / April 2005

Tip: Looking for answers? Try searching our database.

Character Symbols are NOT created equal!

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Frustrated - 07 Apr 2005 14:55 GMT
After much trial and error, I figured out a way to insert a degree symbol
that would merge successfully from an excel file to a word merge document in
2000.  

I also discovered that not all "symbols" are created equal, in that some of
them  DO make the transition during a merge, while others don't (!)

If the  "superscript 0" is used, instead of the actual degree symbol, it
will merge successfully!  However, the superscript 0 cannot be inserted using
the numeric keypad (alt-0186), but must first be inserted into a Word
document, then copied and pasted into the excel spreadsheet formula.

Wolla!
Peter Jamieson - 08 Apr 2005 10:40 GMT
Well researched!

I have to say I am able to insert a superscript 0 using Alt 0186 here. But
in Excel you could consider using the  Windows Character Map (by default,
under Start|Programs|Accessories|System Tools) to select and enter the
character. The Character Map isn't installed by default so you might need to
go to the Control Panel|Add/Remove software to install it. I don't know if
there is a better way to do it - you might try an Excel newsgroup.

Peter Jamieson
> After much trial and error, I figured out a way to insert a degree symbol
> that would merge successfully from an excel file to a word merge document
[quoted text clipped - 12 lines]
>
> Wolla!
Frustrated - 08 Apr 2005 14:33 GMT
Thanks, Peter.   I did try looking up the Character Map in Excel, but as you
mentioned, it had not been downloaded.   I would have to go through my IT
center to get  that accomplished, so I resorted to other tactics.

I also tried the "file conversion" on merging the excel file, but that only
gave me compressed data that was totally illegible.

Still, I appreciate your help and am glad I found this newsgroup!

> Well researched!
>
[quoted text clipped - 22 lines]
> >
> > Wolla!
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.