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.

Merge loses "symbol" character when taken from an excel spreadshee

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Frustrated - 05 Apr 2005 15:13 GMT
I am trying to merge an excel file that has data imported from a text file.  
I have included a column with a function to "substitute" a "d" in a character
string to the "degree symbol."  This works fine in excel, but when I merge
the field into my Word form, it loses the symbol!  I entered the symbol in
the excel cell function using the character number  "0176" as shown in Word's
Latin-1 symbol set.  I have tried to set the word merge field with format
"switches," etc., to no avail.

I am going MAD trying to figure out how to get the degree symbol to show up
in my form!  Can you help?!

Frustrated
Peter Jamieson - 05 Apr 2005 15:26 GMT
Which version of Excel/Word?

Peter Jamieson

>I am trying to merge an excel file that has data imported from a text file.
> I have included a column with a function to "substitute" a "d" in a
[quoted text clipped - 11 lines]
>
> Frustrated
Frustrated - 05 Apr 2005 15:45 GMT
> Which version of Excel/Word?
>
[quoted text clipped - 17 lines]
>
> Sorry....2000 for PC
Peter Jamieson - 05 Apr 2005 17:50 GMT
Yes, this character does not appear to get through when you use the default
connection method (DDE), or the ODBC connection method. Try connecting
again, but in the Open Data Source dialog box, check  "Select method" and
choose the "Microsoft Excel Worksheet via Converter" option. Another
approach would be to select the spreadsheet, Edit|Copy, then Paste|Special
in RTF format into a blank Word document to create a Word table, then use
that as the data source.

Peter Jamieson

>> Which version of Excel/Word?
>>
[quoted text clipped - 22 lines]
>>
>> Sorry....2000 for PC
Frustrated - 05 Apr 2005 16:25 GMT
Sorry...Word 2000 for PCs

> Which version of Excel/Word?
>
[quoted text clipped - 15 lines]
> >
> > Frustrated
 
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.