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

F

Frustrated

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
 
P

Peter Jamieson

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Matching literal text "???" in Word 2010 field code IF statement 2
International Characters in a merge field 4
Character Symbols are NOT created equal! 2
Word Mail Merge - keeping paragraph breaks that appear in original Excel cell data 2
Merge field truncated to first 18 characters from source? 0
Get the right language when inserting a date 2
Symbol font in report 1
Email Mail Merge via linked Excel sheet 0

Top